use an if function in cell H10 to calculate the commission rate for the total sale for order 1.

please use the cell blocks from the picture attached.

(2.1) Use an If function in (2.2) Copy your formula in (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 ail 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