Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 H 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 absolute references.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started