View attachment 2031481
Looking at the values in the example, I presume a Full Day rate is 65, and half day rate is 45.

To do in one formula you need to use a Nested IF Statement, the logic first looks to see if the value in Cell B2 is Full Days - it will then set the rate to the True value, 65, if not this value the first IF statement returns the 'False' Value, which is a second nested IF statement. The next IF statement then checks to see if B2 contains Half Days, and will return the value of 45, if not then it will return a value of nil. The formula then multiplies the value returned by the Nested IF Statement by the number of days per week.

The IF function returns one of two values, depending on whether a specified expression evaluates to a boolean value of TRUE or FALSE.

**IF**(

*if-expression, if-true*,

*if-false*)

*if-expression: *A logical expression.

*if-true: *The value returned if

*if-expression *is TRUE

*if-false: *An optional argument specifying the value returned if

*if-expression* is FALSE.

The above formula could have been simplified to :

View attachment 2031492
However having only 1 IF Statement only checks that the value in Cell B2 is 'Full Days', if it is not then it will return the FALSE value of 45. The formula would only work if the table was fully completed and Full Days was spelt correctly. If the Value in Column B was left blank or Misspelt then it would return the value of 45, leading to a possible spreadsheet error.

Hope this helps