Insert an IF function in cell F5 to calculate the total due. If the customer has chosen home delivery, there is an additional delivery charge located in cell B25. Be sure to use appropriate relative and absolute cell references

If condition accepts 3 parameters, where the 1st parameter is the condition and second parameter is the one which needs to be executed “if the condition is true” and the third argument is executed when the “condition is false”.

Here the condition is if there is an delivery ie. D5 = yes, then we add some amount of additional charges through the formula (c4*1.05) and if not we retain the base price C4.

Here the additional delivery charges are considered as 5%. You can change the number according to your need.

fichoh fichoh · Answer 2 · 2021-09-22T07:32:04+02:00

The IF function receives a condition and gives a certain specified output if the condition is met and second output if the condition is false. The appropriate formular to perform the operation IS =IF((A5 = 'Yes'), $B$25+C5, C5)

Excel formulas start with an = sign

Syntax IF(Condition, True output, False output)

A5 = 'Yes' : if the customer requested home delivery

Additional charge for home delivery is kept in B25, here we need an absolute reference because we do not want the cell value to change as we move theorgh rows and columns, hence, the need for the $ signs for both row and column cell.

Extra fee is added to total cost in cell C5 = $B$25 + C5

If the condition is not met, that is, A5 = 'No' ; then return C5.

Therefore, the required formula in cell F5 should be

=IF((A5 = 'Yes'), $B$25+C5, C5)

Learn more : https://brainly.com/question/2749852?referrer=searchResults