in excel how to Calculate shipping costs due including shipping and discount?

Excel File Edit View 0 0 G2 Wed 15:43 Q = Insert Format Tools Data Window Help HESUDE I BEH AutoSave OFF A | BT 123 Final Fall 2019 (3) Q Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comme fx Eu ? A vo V A Define Name fx E, Trace Precedents a Trace Dependents FRemove Arrows t HH Calculate Now Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions Create from Selection Show Error Formulas Checking Calculation De Calculate Sheet Options 034 X fx B D E F G H J J L L M N O P Q R s T U V W 2,000 A A 1 Shipping Cost Table 2 Order Amount 3 Standard 4 2-day 5 Overnight 6 $ $ $ $ 200 $ 6 $ 15$ 30$ 500 $ 20$ 27 $ 45$ 750 $ 35 $ 45 $ 60 $ $ 1,000 $ 60 $ 75$ 100$ 50 75 Order Amount Discount 200 400 600 800 1,000 1,200 1,400 1,600 Discount % 0% 3% 4% 5% 6% 7% 8% 9% 10% 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 - Proven Reserves NW Energy EmployeeDate Average Salary Total Amount Paid Number of Employees Summit Products Lookup Data Summit Summary Solar Panels + Ready 1 + 100 Excel File Edit View 0 0 G2 Wed 15:43 Q = Insert Format Tools Data Window Help HESUDE I BEH AutoSave OFF A | BT 123 Final Fall 2019 (3) Q Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comme fx Eu ? A vo V A Define Name fx E, Trace Precedents a Trace Dependents FRemove Arrows t HH Calculate Now Text Insert Function AutoSum Recently Financial Logical Used Date & Lookup & Math & Time Reference Trig More Functions Create from Selection Show Error Formulas Checking Calculation De Calculate Sheet Options 034 X fx B D E F G H J J L L M N O P Q R s T U V W 2,000 A A 1 Shipping Cost Table 2 Order Amount 3 Standard 4 2-day 5 Overnight 6 $ $ $ $ 200 $ 6 $ 15$ 30$ 500 $ 20$ 27 $ 45$ 750 $ 35 $ 45 $ 60 $ $ 1,000 $ 60 $ 75$ 100$ 50 75 Order Amount Discount 200 400 600 800 1,000 1,200 1,400 1,600 Discount % 0% 3% 4% 5% 6% 7% 8% 9% 10% 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 - Proven Reserves NW Energy EmployeeDate Average Salary Total Amount Paid Number of Employees Summit Products Lookup Data Summit Summary Solar Panels + Ready 1 + 100