Assignment Tasks

Use an IF function in cell J$18$ to calculate the commission earned for beverages for order $1.$ The beverage commission is $10\%$ of the total sale if the customer buys a beverage. If the

$5$

beverage sale amount $($cell D$18)$ is greater than $0$ the beverage commission equals the sales total $($cell G$18)$ multiplied by the beverage commission rate $($cell G$12).$ Otherwise the beverage commission is $0.$ Use appropriate relative and absolute cell references. $[5$ points$]$