Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Use an IF function in cell H18 to calculate the commission rate for the total sa

ID: 675005 • Letter: U

Question

Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references.

Explanation / Answer

This formula assumes:
Sales total is in A1
F13 is 10
F14 is 5
G13 is .02
G14 is .01

=IF(A1>$F$13,A1*$G$13,IF(A1>$F$14,A1*$G...

Related Questions

Use a t-test to test the claim about the population mean mu at the given level o
Question #3270340
Use a t-test to test the claim about the population mean mu at the given level o
Question #3291191
Use a t-test to test the claim about the population mean mu at the given level o
Question #3296955
Use a table of Standard Reduction Potentials to predict if a reaction will occur
Question #513205
Use a table of Standard Reduction Potentials to predict if a reaction will occur
Question #587076
Use a table of areas to find the specified area under thestandard normal curve:
Question #2914947
Use a table of cumuliative areas under the normal curve to find the z-score that
Question #2906879
Use a table of values to estimate the value of the limit. If you have a graphing
Question #3346664

Navigate

Previous
Use an Excel spreadsheet and the FV, PV, and PMT functions todetermine the amoun
Next
Use an IP calculator, such as the one available at http:lliodies.delipcalc to co

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.