a$.$ C stomer are charged $$\mathrm{.}50$ per di lut unless they buy a dozen or iore. In this case, they are che red $$\mathrm{.}40$ a dont

b$.$ Refe ne appropriate price in cells C$3)$ and C$4)$ for your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments.

c$.$ Use absolute and relative references when appropriate.

$10$

$2\mathrm{.}2$ Copy your formula in cell

$2\mathrm{.}3$ Use an IF function in cell $H10$ 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 comritission 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.