Assignment Tasks

Use an IF function in cell E$18$ to calculate the price to charge per donut for order $1.$ A customer is charged $$\mathrm{.}50$ per donut unless they buy a dozen or more. In this case, they are $1$ charged $$\mathrm{.}40$ a donut. Refer to the appropriate price in cells $C11$ and $C12$ for your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments. Use absolute and relative references when appropriate. $[5$ points$]$