Question: 2 . 3 Use an IF function in cell H 1 0 to calculate the commission rate for the donuts sale for order 1 .
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 your "valueiftrue" and "valueiffalse" arguments.
d Use appropriate relative and
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
