Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Question Use an IF function 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 beverage sale amount(cell D18) is greater than o the beverage commission equals the sales total (cell G18) multiplied by the beverage commission rate (G12). Otherwise the beverage commission is 0. Use appropriate relative and absolute cell references.

/in /by

Question

Use an IF function 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 beverage sale amount(cell D18) is greater than o the beverage commission equals the sales total (cell G18) multiplied by the beverage commission rate (G12). Otherwise the beverage commission is 0. Use appropriate relative and absolute cell references.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"