In the shipping cell (H29), enter a formula that nests the VLOOKUP function in an IF function to lookup the shipping costs from the Shipping Cost Table in the Pricing and Shipping worksheet based on the subtotal in cell H27. If the subtotal is 0, the shipping cost should display 0.?

The shipping cost for order amount 100 is 0.

Transcribed Image Text:

13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A ▶ B n Item Gourmet (2) 1 g Plain tin 1 g Notes: Standard Popcorns Natural Buttered D E White Cheddar Cheesy Cheddar Documentation Customer Invoice Flavor Nacho Cheese Gourmet Popcorns Too Hot to Handle Chipotle BBQ Nacho Cheese Cinnamon & Brown Sugar Pricing and Shipping + F Price 2 $25.00 1 $ 5.00 Qty Total $ 50.00 $ 5.00 AAAAAAAAAAAAAAAAAAA $ $ $ $ H $ - Subtotal $ 55.00 Sales Tax $ 3.77 Shipping Total Due $ 58.77 J A Product Pricing 1 2 Item 3 Standard (1) 1 g 4 Gourmet (1) 1 g 5 Standard (2) 1 g 6 Gourmet (2) 1 g 7 Standard (3) 1g 8 Gourmet (3) 1g 9 Standard (1) 2 g 10 Gourmet (1) 2 g 11 Standard (2) 2 g 12 Gourmet (2) 2 g 13 Standard (3) 2 g 14 Gourmet (3) 2 g 15 Standard (1) 3 g 16 Gourmet (1) 3 g 17 Standard (2) 3 g 18 Gourmet (2) 3 g 19 Standard (3) 3 g 20 Gourmet (3) 3 g 21 Plain tin 1 g 22 Fancy tin 1g 23 Plain tin 2 g 24 Fancy tin 2 g Ready B B Documentation с D E Shipping Cost Table Order Amount 5 15 25 50 100 Shipping Cost 4.00 8.50 12.50 16.00 Price $ 15.00 $ 20.00 $ 20.00 $ 25.00 $ 25.00 $ 30.00 $ 20.00 $ 25.00 $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 35.00 $ 40.00 $ 5.00 $ 7.00 $ 8.00 $ 10.00 Customer Invoice Pricing and Shipping $ $ in in $ $ $ F G H 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A ▶ B n Item Gourmet (2) 1 g Plain tin 1 g Notes: Standard Popcorns Natural Buttered D E White Cheddar Cheesy Cheddar Documentation Customer Invoice Flavor Nacho Cheese Gourmet Popcorns Too Hot to Handle Chipotle BBQ Nacho Cheese Cinnamon & Brown Sugar Pricing and Shipping + F Price 2 $25.00 1 $ 5.00 Qty Total $ 50.00 $ 5.00 AAAAAAAAAAAAAAAAAAA $ $ $ $ H $ - Subtotal $ 55.00 Sales Tax $ 3.77 Shipping Total Due $ 58.77 J A Product Pricing 1 2 Item 3 Standard (1) 1 g 4 Gourmet (1) 1 g 5 Standard (2) 1 g 6 Gourmet (2) 1 g 7 Standard (3) 1g 8 Gourmet (3) 1g 9 Standard (1) 2 g 10 Gourmet (1) 2 g 11 Standard (2) 2 g 12 Gourmet (2) 2 g 13 Standard (3) 2 g 14 Gourmet (3) 2 g 15 Standard (1) 3 g 16 Gourmet (1) 3 g 17 Standard (2) 3 g 18 Gourmet (2) 3 g 19 Standard (3) 3 g 20 Gourmet (3) 3 g 21 Plain tin 1 g 22 Fancy tin 1g 23 Plain tin 2 g 24 Fancy tin 2 g Ready B B Documentation с D E Shipping Cost Table Order Amount 5 15 25 50 100 Shipping Cost 4.00 8.50 12.50 16.00 Price $ 15.00 $ 20.00 $ 20.00 $ 25.00 $ 25.00 $ 30.00 $ 20.00 $ 25.00 $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 35.00 $ 40.00 $ 5.00 $ 7.00 $ 8.00 $ 10.00 Customer Invoice Pricing and Shipping $ $ in in $ $ $ F G H

Answer rating: 100% (QA)

The formula in the cell H29 that nests the VLOOKUP function in a... View the full answer