need help with no. 10 and 11 pls.

need to know how to type the formula in.

6. In the Price cell (cell Glb), use listed in the Product Pricing table in the Pricing and Shipping worksheet. (Hint: Use the defined name ProductPrice that was assigned to the Product Pricing table.) When no item is selected, this cell will display an error message. 7. Modify the formula in the cell G16 by combining the IFERROR function with the VLOOKUP function to display either the price or a blank cell if an error value occurs. Copy the formula down the range G16:G26. 8. In the Total column (range H16:H26), enter a formula to calculate the total charge for that row (Qty * Price). Use the IFERROR function to display either the total charge or a blank cell if an error value occurs. 9. In the Subtotal cell (cell H27), add a formula to sum the Total column. Use the IFERROR function to display either the subtotal or a blank cell if an error value occurs. 10. In the Sales Tax cell (cell H28), enter a formula with an IF function so if the customer's state (cell C12) is NV, then calculate 6.85 percent of the subtotal (cell H27); otherwise, use 0 for the sales tax. (Hint: The defined name State is assigned to cell C12, and the defined name Sub_Total is assigned to cell H27. Note that the defined name "Sub_Total" is intentionally not spelled as "Subtotal," which is the name of an Excel function.) 11. In the Shipping cell (cell H29), enter a formula that nests the VLOOKUP function in an IF function to look up the shipping cost 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. (Hint: Use the defined name you created for the Shipping Cost table data.) 12. In the Total Due cell (cell H30), calculate the invoice total by entering a formula that adds the values in the Subtotal, Sales Tax, and Shipping cells. 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