Question: Use an IF function in cell H 1 8 to calculate the commission rate for the total sale for order 1 . The commission rate
Use an IF function in cell H to calculate the commission rate for the total sale for order
The commission rate is for all sales that total more than $ and for all sales that total
more than $ No commission is paid on sales that total $ or less. 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 "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
