Question: Complete the table on the IF Function worksheet to help Beverly calculate her commission based on the 5 0 customers she helped this morning. 2

Complete the table on the IF Function worksheet to help Beverly calculate her commission based on the 50 customers she helped this morning.
2.1 Use an IF function in cell E10 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 (3) and (4) for your "va_e_if_true" and "value_if_false" arguments.
c. Use absolute and relative references when appropriate.
5
2.2 Copy your formula in cell
E10) and paste it down to complete the "Price/Donut" column of the table.
 Complete the table on the IF Function worksheet to help Beverly

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 General Management Questions!