Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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