Use an IF function in Cell G15 to calculate the Net Price. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount of 5% applied if 10 or more are ordered. Refer to the appropriate discounts in cells E10, E11 and E12 for you If function arguments. Use absolute and relative references when appropriate.

2 UT OR All Others 13 14 25 26 27 28 29 30 31 32 33 35 36 Sales Tax Rate 37 38 39 40 41 42 43 OrderID *A Ready Ship To 1003 AZ 1004 WA 1007 NV 1011 UT 1027 1041 1042 5% 6% 0% 1050 1058 1059 1060 1062 CA MT CA OR UT AZ WA UT 1073 1074 1088 WA NV 1094 1109 HI 1120 OR 1255 OR 1262 UT 1265 WA 1267 CA 1268 MT 1364 AZ 1417 UT 1629 CA 1635 CO 1661 AZ 1666 OR 4C33 LAJA ProductID Quantity Break Point Product Name 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 100 QuickStove 102 Replacement Fuel Cells 104 Quick Stove Can 104 Quick Stove Can 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 104 Quick Stove Can 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 102 Replacement Fuel Cells 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 106 Stove In A Can 108 QuickStove Fuel Disk 107 SIAC Fuel Cell 106 Stove In A Can 107 SIAC Fuel Cell 107 SIAC Fuel Cell 1 2 10 Discount Unit Price Quantity Net Price 17.55 4 $ 0.35 17.55 5 #VALUE! 17.55 17.55 17.55 4.00 $ $ $ $ $ $ $ S $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 0% 2% 5% $ $ 34.99 34.99 34.99 4.00 34.99 4.00 34.99 4.00 4.00 4.00 4.00 4.00 34.99 34.99 34.99 34.99 34.99 34.99 Cal Dial Boolean Functions If Function Lookup Functions Conditional Functions 1.66 5.00 34.99 5.00 5.00 7 #VALUE! 7 #VALUE! 1 #VALUE! 1 #VALUE! 2 #VALUE! 8 #VALUE! 8 #VALUE! 4 #VALUE! 2 #VALUE! 16 #VALUE! 1 #VALUE! 5 #VALUE! 1 #VALUE! 2 #VALUE! 2 #VALUE! 10 #VALUE! 1 #VALUE! 3 #VALUE! 1 #VALUE! 3 #VALUE! #VALUE! 12 #VALUE! 24 #VALUE! 2 #VALUE! 2 #VALUE! 10 #VALUE! 4 #VALUE! MIALLIPI Total Sales Total Tax Grand Total Sale Amt