I have already taken this test, but I need to figure out what the formula for the freight cost is that takes into consideration every state and shipping rate accounted for in the format of HLOOKUP(IF

12:38 AA coursehero.com Arizona State University - CIS 105 > LogicAndReferenceQS-r8.xIsm LogicAndReferenceQS- r8.xIsm Rate 5 more documents to earn a free unlock. Helpful Unhelpful 15 of 23 - + Freight Cost NV UT CA MT OR CO HI 5.00 $ 3.00 $ 5.00 $ 6.00 $ 6.00 $ 5.00 $ 8.00 7.60 $ 4.70 $ 7.60 $ 8.40 $ 8.40 $ 7.60 $ 13.50 11.60 $ 7.80 $ 11.60 $ 13.70 $ 13.70 $ 11.60 $ 17.10 Shipping Insurance Cost Freight Cost Total Shipment Insurance 7.60 $ 10.10 Value Cost 8.40 $ 10.90 0.50 5.00 $ 8.00 10 1.00 4.70 $ 7.70 30 $ 2.00 11.60 $ 12.60 50 2.50 13.70 $ 14.20 100 $ 3.00 11.60 $ 14.10 200 $ 4.00 13.70 $ 17.70 400 $ 5.00 4.70 $ 8.70 5.00 $ 6.00 13.70 $ 16.20 3.00 $ 5.50 11.60 $ 13.60 11.60 $ 12.60 13.70 $ 14.20 7.60 $ 8.10 13.50 $ 14.00 8.40 $ 10.40 13.70 $ 15.70 3.00 $ 6.00 8.40 $ 10.40 11.60 $ 14.60 6.00 $ 8.00 5.00 $ 9.00 7.80 $ 9.80 7.60 $ 8.60 7.60 $ 10.10 5.00 $ 7.00 8.40 $ 9.40 8.40 $ 10.40 11.60 $ 12.60 on the 11.60 $ 12.60 11.60 $ 12.6012:38 AA coursehero.com Arizona State University - CIS 105 > LogicAndReferenceQS-r8.xIsm LogicAndReferenceQS- r8.xIsm Rate 5 more documents to earn a free unlock. Helpful Unhelpful 11 of 23 When shipping products two major costs are incurred: the cost of ensuring the item and the actual freight cost. Insurance is dependent on the value of the shipment AZ WA Quickstove has an agreement with shippers for a fixed rate that is Regular 5.00 $ 6.00 determined by destination state and service level (regular , express or overnite) Express 7.60 $ 8.40 Overnite 11.60 $ 13.70 Shipping Insurance OrderID Ship To ProductID Product Name Value Class Cost 1003 AZ 100 QuickStove $ 68.80 Express 2.50 1004 WA 100 QuickStove $ 86.00 Express 2.50 1007 NV 100 QuickStove $ 120.39 Regular 3.00 1011 UT 100 QuickStove $ 120.39 Express 3.00 1027 CA 100 QuickStove 17.55 Overnite 1.00 1041 MT 102 Replacement Fuel Cells 4.00 Overnite 0.50 1042 CA 104 Quick Stove Can $ 69.98 Overnite 2.50 1050 OR 104 Quick Stove Can $ 274.32 Overnite 4.00 1058 UT 104 Quick Stove Can $ 274.32 Express 4.00 1059 AZ 102 Replacement Fuel Cells 15.68 Regular 1.00 1060 WA 104 Quick Stove Can 69.98 Overnite 2.50 1062 UT 102 Replacement Fuel Cells $ 60.80 Regular 2.50 1073 co 104 Quick Stove Can $ 34.99 Overnite 2.00 1074 Co 102 Replacement Fuel Cells 19.60 Overnite 1.00 1088 WA 102 Replacement Fuel Cells 4.00 Overnite 0.50 1094 NV 102 Replacement Fuel Cells 8.00 Express 0.50 1109 HI 102 Replacement Fuel Cells 8.00 Express 0.50 1120 OR 102 Replacement Fuel Cells 38.00 Express 2.00 1255 OR 106 Stove In A Can 34.99 Overnite 2.00 1262 UT 106 Stove In A Can $ 102.87 Regular 3.00 1265 WA 106 Stove In A Can $ 34.99 Express 2.00 1267 CA 106 Stove In A Can $ 102.87 Overnite 3.00 1268 MT 106 Stove In A Can $ 34.99 Regular 2.00 1364 AZ 106 Stove In A Can $ 398.89 Regular 4.00 1417 UT 108 QuickStove Fuel Disk $ 37.85 Overnite 2.00 1629 CA 107 SIAC Fuel Cell $ 10.00 Express 1.00 1635 Co 106 Stove In A Can $ 69.98 Express 2.50 1661 AZ 107 SIAC Fuel Cell 47.50 Regular 2.00 107 SIAC Fuel Cell m