contestada

Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your "value_if_true" and "value_if_false" arguments

Respuesta :

stadavies

Answer:

Price per Donut Commission Rate Total Sales $396.53 0-11 0.SD Type Threshold Rate Total Commission 23.B2 12 + 0.4D Beverage Sales > $ 5 $ 5.0D l09â 1% Buy a Donut? Sales > $ ID $ 10.0D 2% Sales Arrtount Order # It I onutx Beverage Price/L¥onut Oonutx b0 $0.0D 0.40 $24.D0 $24.00 2% $0.48 $D.00 $D.48 12 $D.DD 0.4D 4.BD $4.B0 0% $0.DD $D.DD $D.DD 48 $66.24 0.40 $19.20 $85.44 2% $0.3B $6.62 $7.D1 24 $37.2D 0.40 $9.g0 4g.80 1% $0.10 $3.72 $3.B2 10 $0.OD 0.50 QS.DO $5.00 0% $0.DO $D.00 $D.DO 3 $0.0D 0.30 $1.30 $1.30 0% $0.D0 ID.00

Otras preguntas