AutoSum 2 Logical Recently Used V Insert Function A Text OM Financial 9 Date & Time M Function Library H29 X fo =IF(F16='Pricing ar B D 1 F 2 3 4 5 5 E Shivani Patel 0752858 Ricky's Popcorn 1024 South Main Hawthorne, Nevada 89145 (775) 555-1212 6 9 7 8 9 9 Date Sold: 12/1/2017 10 Sold to Lauri Bradford 3226 South Street Hawthrone NV 89415 11 12 13 14 15 Flavor Item Gourmet (2119 Plain tin 19 Nacho Cheese Qty Price 2 $ 25.00 1 $ 25.00 Total 50 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Hotes: Subtotal $ 50.00 Sales Tax S Shipping $ Total D. $ 5000 Standard Popcorn Gourmet Popcorn Natural Too Hatta Handle Documentation Customer Invoice Pricing Ready AutoSum 2 Logical Recently Used V Insert Function A Text OM Financial 9 Date & Time M Function Library H29 X fo =IF(F16='Pricing ar B D 1 F 2 3 4 5 5 E Shivani Patel 0752858 Ricky's Popcorn 1024 South Main Hawthorne, Nevada 89145 (775) 555-1212 6 9 7 8 9 9 Date Sold: 12/1/2017 10 Sold to Lauri Bradford 3226 South Street Hawthrone NV 89415 11 12 13 14 15 Flavor Item Gourmet (2119 Plain tin 19 Nacho Cheese Qty Price 2 $ 25.00 1 $ 25.00 Total 50 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Hotes: Subtotal $ 50.00 Sales Tax S Shipping $ Total D. $ 5000 Standard Popcorn Gourmet Popcorn Natural Too Hatta Handle Documentation Customer Invoice Pricing Ready Insert Function Recently Used A Text @ Math Financial Date & Time More Function Library H29 =IF(F16='Pricing and S B 4 A 21 D E 22 23 24 25 26 27 Notes: 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Standard Popcoms Natural Buttered White Cheddar Cheesy Cheddar Kettlecorn Cajun Sour Cream in Chive Salt 'n Vinegar Caramel Gourmet Popcorns Too Hot to Handle Chipotle BBQ Nacho Cheese Cinnamon & Brown Sugar Grape Orange Key Lime Island Coconut Cookies & Cream Documentation Customer Invoice Ready Pricing and sh . AutoSave OH 12 File Home Insert Page Layout Formulas Data Review View fx Autosum Logical Lookup & Reference Recently Used A Text O Math & Trig Insert Function N N Mar Financial 9 Date & Time More Functions Function Library B21 > fx 5 D E Shipping Cost Table Order Amount Shipping Cost 5 $ 4.00 15 $ 8.50 25 $ 12.50 50 $ 16.00 100 $ A B 1 1 Product Pricing 2 Item Price 3 Standard (1) 1 g $ 15.00 4 Gourmet (1)1g $ 20.00 5 Standard (2)1g $ 20.00 6 Gourmet (2)1g $ 25.00 7 Standard (3)1g $ 25.00 8 Gourmet (3)18 S 30.00 9 Standard (1) 28 $ 20.00 10 Gourmet (1) 2 g $ 25,00 11 Standard (2) 2 2 $ 25.00 12 Gourmet (2) 28 $ 30.00 13 Standard (3) $ 30.00 14 Gourmet (3) 28 $ 35.00 15 Standard (1) 3 g $ 25.00 16 Gourmet (1) 3 $ 30,00 17 Standard (2) SE $ 30.00 18 Gourmet (2) 38 $ 35.00 19 Standard (3) 3 g $ 35.00 Documentation Customer invoice Pricing and Shipping Ready E O 99 AutoSave OH H 12 File Home Insert Page Layout Formulas Data 2 Logical Lookup & fx Autosum Recently Used A Text Math & Insert Function Financial Date & Time More Fun Function Library B21 5 A B D $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 25.00 $ 30.00 $ 30.00 $ 35.00 $ 35.00 11 Standard (2) 28 12 Gourmet (2)2g 13 Standard (3) 2g 14 Gourmet (3)2 g 15 Standard (1) 3 g 16 Gourmet (1)3g 17 Standard (2) 3g 18 Gourmet (2)3 g 19 Standard (3) 3 g 20 Gourmet (3) 3 g 21 Plain tin 1 g 22 Fancy tin 18 23 Plain tin 2 g 24 Fancy tin 2 g 25 Plain tin 3 g 26 Fancy tin 3 g 27 28 29 $ 40.00 S 5.00 $ 7.00 $ 8.00 $ 10.00 $ 11.00 $ 13.00 Documentation Customer invoice Pricing Read