Question: Use an IF function in cell H10 to calculate the commission rate for the donuts sale for order 1. The commission rate is 2% for

Use an IF function in cell H10 to calculate the commission rate for the donuts sale for order 1. The commission rate is 2% for donuts sales that total more than $10. It is 1% for all donuts sales that total more than $5, but are less than or equal to $10. No commission is paid on donut sales that total $5 or less. Reference the threshold levels (cells F5 and F6) in your logical tests for your IF function and the commission rates (cells G5 and G6) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references

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