9. In column U, enter a formula to compute the total Tax amount for the line item. The tax applies to the line subtotal minus the discount. Use the VLOOKUP function to get the tax rate from the table Tax, using the customers State (column F) as the lookup value. Apply the Currency format to the column.

U2 # fx D E F G H 1 Address 2 7142 White Oak Lane 3 7142 White Oak Lane 4 7142 White Oak Lane 5 809 South Columbia 6 809 South Columbia Erie 7 1009 South Main Stree Monon 8 1009 South Main Stree Monon City State Zip Salesperson Sacramento CA 94203 Steven Buchanan Sacramento CA 94203 Steven Buchanan Sacramento CA 94203 Steven Buchanan Erie PA 16501 Michael Suyama PA 16501 Michael Suyama IN 46307 Peggy Peacock IN 46307 Peggy Peacock 9 1009 South Main Stree Monon IN 46307 Peggy Peacock 10 901 Church St. Columbus OH 43085 Janet Leverling 11 901 Church St. Columbus OH 43085 Janet Leverling 12 901 Church St. Columbus OH 43085 Janet Leverling 13 44 Webster Drive Roswell NM 88201 Peggy Peacock 14 44 Webster Drive Roswell NM 88201 Peggy Peacock 15 44 Webster Drive Roswell NM 88201 Peggy Peacock 16 1009 South Main Stree Monon IN 46307 Janet Leverling 17 1009 South Main Stree Monon IN 46307 Janet Leverling X T SP_Address 4525 Urn Hollow Road 4525 Urn Hollow Road 4525 Urn Hollow Road 8237 Justice Way 8237 Justice Way 109 Hill Haven Drive 109 Hill Haven Drive 109 Hill Haven Drive 5612 Bon Aqua 5612 Bon Aqua 5612 Bon Aqua 109 Hill Haven Drive 109 Hill Haven Drive 109 Hill Haven Drive 5612 Bon Aqua 5612 Bon Aqua J K M SP_City SP_State SP_Zip ProductName Olive Branch MS 38654 Mozzarella di Giovanni Olive Branch MS 38654 Queso Cabrales Olive Branch MS St. Louis St. Louis MO Toledo OH Toledo OH Toledo OH MI 38654 Singaporean Hokkien Fried Mee 63101 Tofu 63101 Manjimup Dried Apples 43604 Louisiana Fiery Hot Pepper Sauce 43604 Manjimup Dried Apples 43604 Jack's New England Clam Chowder Ann Arbor 48109 Louisiana Fiery Hot Pepper Sauce Ann Arbor MI 48109 Gustaf's Knckebrd IMI 48109 Ravioli Angelo 43604 Camembert Pierrot Ann Arbor Toledo Toledo Toledo Ann Arbor Ann Arbor 43604 Sir Rodney's Marmalade 43604 Geitost 48109 Maxilaku 48109 Gorgonzola Telino OH OH OH MI MI N O P R UnitPrice Quantity Line Subtot Promo Freight $10.70 20 $214.00 Yellow $49.35 $17.98 15 $269.70 $14.30 $11.13 7 $77.91 $14.30 $35.58 30 $1,067.40 $434.54 $19.26 6 $115.56 $434.54 4 $77.04 $4.67 4 $77.04 $69.94 5 $55.65 $10.70 $19.26 100 $1,926.00 Red $876.45 $13.38 44 $588.72 Red $422.86 $52.76 30 $1,582.80 Red $422.86 $16.59 20 $331.80 $0.87 $35.10 25 $877.50 $89.51 $20.33 12 $243.96 $9.20 $10.17 30 $305.10 $219.97 $6.64 4 $26.56 Red $17.17 $19.26 $19.26 $11.13 $0.00 $0.00 S T U V DiscPerc DiscountAmt Tax Line Total 25% $53.50 0% $0.00 0% $0.00 0% $0.00 0% 0% 0% 0% 25% 25% 25% 0% 0% 0% 0% $0.00 $0.00 $481.50 $147.18 $395.70 $0.00 $0.00 $0.00 $0.00 $6.64 25% A 2 3 Promotion 4 Yellow 5 Tan 6 Blue 7 Green 8 Red 11 Overdue PROSPERHEN~~~~8885888885883599399599 10 12 13 14 15 16 17 18 19 Interest 3 4 20 21 22 23 24 25 26 27 28 29 30 31 32 34 36 37 40 41 42 43 44 45 46 47 48 49 CO m 5 1