Question: 2 . 1 Use an IF function in cellE 1 0 to calculate the price to charge per donut for order 1 . a .

2.1 Use an IF function in cellE10 to calculate the price to charge per donut for order 1.a. Customer are charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut.b. Refer to the appropriate price in cells C3 and C4 for your"value_if_true" and"value_if_false" arguments.c. Use absolute and relative references when appropriate.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!