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

$2\mathrm{.}5$ Use an If function in cell $($J$10)$ to calculate the commission earned for beverages for order $1.$

a$.$ The beverage commission is $10\%$ of the total sale if the customer buys a beverage.

$b.$ If the beverage sale amount $($cell $($D$10)$ is greater than $0,$ the beverage commission equals the sales total $($cell G$10$ I multiplied by the beverage commission rate $($cell G$4)).$

c$.$ Otherwise, the beverage commission is $0.$

d$.$ Use appropriate relative and absolute cell references.

$10$

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