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

Question

Computers & Technology

Derrick Lang

13 September, 04:21

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

+1

Answers (2)

Know the Answer?

Isaias Arias · Answer 1

=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.

Bridger Wilkins · Answer 2

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.