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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
