MyEducator Tasks

$2\mathrm{.}3$ Use an IF function in cell H$10$ to calculate the commission rate for the donuts sale for order $1.$

a$.$ The commission rate is $2\%$ for donuts sales that total more than $$10.$ It is $1\%$ for all donuts sales that total more than $$5,$ but are less than or equal to $$10.$

b$.$ No commission is paid on donut sales that total $$5$ or less.

c$.$ Reference the threshold levels $($cells $($F$5)$ and $($F$6)$ in your logical tests for your IF function and the commission rates $($cells G$5)$ and G$6)$ as your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments.

d$.$ Use appropriate relative and absolute references.