Copy your formula in cell E$18$ and paste it down to complete the "Price$/$Donut$"$ column of the table.

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 F$13$ and F$14)$ in your logical tests for your IF function and the commission rates $($cells G$13$ and G$14)$ as your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments. Use appropriate relative and absolute references.