Question

How much would the company saved in 2012 if it has free shipping instead of the 1% discount in extra large, orders using the store. sales 2012

Answer 1

Using your newly created “Expanded Order Type” column, calculate the total “Sales” for all orders of “Medium” type (rounded to 2 decimal places). Hint: The SUMIF() function is useful here.

2. The company gives a 1% discount on any Extra Large or larger orders. In the “Discount”

a. VLOOKUP formula

b. HLOOKUP formula

c. Nested IF formula

d. IF formula