D 1 Pricing Information for Torres Balls 3 Unit Pricing aty Shipping costs Sicah Seach S 6 7 B 9 10 0 $ BUS 120 5 240 2.45 2.27 2:12 2.00 Method Trusk RAI PU Shis Customer 0.25 0.20 15 Tocal Price: Shipping Discount Shipping count 0$ 0X 3005 10% 1999 $ 15% Shipping Discount Grand Total 2010 2:5 Order 12 CustID Shipping Unit Quantity Price Total Price Unit Shipping Total Shipping 13 1 A0243 Rall 14 2 MH394 Rail 30 15 3 ROB Shop 160 16 a XZT1 Truck 17 5 N1271 Thick 90 18 E CD031 Customer 15 19 20 21 Add formulas in calls Highlighted in blue and perform hasit lookups to calculate & evaluate data 22 Requrements 1. Lookup Unit Price, Vit Shipping & Shipping Discount 23 2. Calculate "Tntal Price Toll Shipping & Grand Total hesed on the formation retrieved 24 2. The 1. Le corretange_lookup value (TRLF VS. FAISF) 26 2. Be careful with the reference to use Absolutelative, or mixed). In other words, make sure the reference is correct won using ril handler to automatically generate formulas. 27 D 1 Pricing Information for Torres Balls 3 Unit Pricing aty Shipping costs Sicah Seach S 6 7 B 9 10 0 $ BUS 120 5 240 2.45 2.27 2:12 2.00 Method Trusk RAI PU Shis Customer 0.25 0.20 15 Tocal Price: Shipping Discount Shipping count 0$ 0X 3005 10% 1999 $ 15% Shipping Discount Grand Total 2010 2:5 Order 12 CustID Shipping Unit Quantity Price Total Price Unit Shipping Total Shipping 13 1 A0243 Rall 14 2 MH394 Rail 30 15 3 ROB Shop 160 16 a XZT1 Truck 17 5 N1271 Thick 90 18 E CD031 Customer 15 19 20 21 Add formulas in calls Highlighted in blue and perform hasit lookups to calculate & evaluate data 22 Requrements 1. Lookup Unit Price, Vit Shipping & Shipping Discount 23 2. Calculate "Tntal Price Toll Shipping & Grand Total hesed on the formation retrieved 24 2. The 1. Le corretange_lookup value (TRLF VS. FAISF) 26 2. Be careful with the reference to use Absolutelative, or mixed). In other words, make sure the reference is correct won using ril handler to automatically generate formulas. 27