MyEducator Tasks E 1 2.3 Use an IF function in cell H10 to calculate the commission rate for the total sale for order 1. a. The commission rate is 2% for all sales that total more than $10. It is 1% for all sales that total more than $5, but are less than or equal to $10. b. No commission is paid on sales that total $5 or less. c. Reference the threshold levels (cells F5 and F6) in your logical tests for your IF function and the commission rates (cells G5 and G6) as your "value_if_true" and "value_if_false" arguments. d. Use appropriate relative and absolute references. 5 Price Per Donut 0 - 11 $0.50 12 $0.40 Total Sales Total Commission $669.75 $0.00 Commission Rates Type Threshold Beverage Sales > $5 $5.00 Sales > $10 $10.00 Rate 10% 1% 2% Buy a donut? Donut Threshold $40.00 Rate N 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 w Sales Amount Order # #Donuts Beverage Price/Donut Donuts 1 60 $0.00 $0.40 $24.00 12 $0.00 $0.40 $4.80 3 48 $66.24 $0.40 $19.20 4 24 $37.20 $0.40 $9.60 5 10 $0.00 $0.50 $5.00 6 3 $0.00 $0.50 $1.50 7 6 $7.50 $0.50 $3.00 8 48 $0.00 $0.40 $19.20 9 36 $56.88 $0.40 $14.40 10 6 $0.00 $0.50 $3.00 11 4 $0.00 $0.50 $2.00 12 3 $0.00 $0.50 $1.50 13 9 $11.61 $0.50 $4.50 14 24 $0.00 $0.40 $9.60 15 7 $0.00 $0.50 $3.50 16 10 $0.00 $0.50 $5.00 17 2 $0.00 $0.50 $1.00 18 60 $0.40 $24.00 Total $24.00 $4.80 $85.44 $46.80 $5.00 $1.50 $10.50 $19.20 $71.28 $3.00 $2.00 $1.50 $16.11 $9.60 $3.50 $5.00 $1.00 $24.00 Commissions Sales Beverage Total Commission $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 w $0.00