Ask Question
29 July, 06:28

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.

+5
Answers (1)
  1. 29 July, 09:03
    0
    IF Function! H18: = IF (G18>$F$14,$G$14, IF ($F$14>G18>$F$13,$G$13))
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers