Question: 2 . 3 Use an IF function in cell to calculate the commission rate for the donuts sale for order 1 . a . The
Use an IF function in cell to calculate the commission rate for the donuts sale for order
a The commission rate is for donuts sales that total more than $ It is for all donuts sales that total more than $ but are less than or equal to $
b No commission is paid on donut sales that total $ or less.
c Reference the threshold levels cells F and F in your logical tests for your IF function and the commission rates cells G and G as
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
