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

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)

Therefore, the required formula in cell F5 should be

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

Learn more : link

=IF((D5="Yes"),(C4*1.05),C4)

Explanation:

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.

1. the seasons of the world

i do not get the question.