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 customers she helped this morning.
Use an IF function in cell E to calculate the price to charge per donut for order
a Customer are charged $ per donut unless they buy a dozen or more. In this case, they are charged $ a donut.
b Refer to the appropriate price in cells and for your vaeiftrue" and "valueiffalse" arguments.
c Use absolute and relative references when appropriate.
Copy your formula in cell
E and paste it down to complete the "PriceDonut column of the table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
