(Solved) : 8 Calculate Discount Amount Order F25 Order Subtotal 100 15 Discount Applied Discount Perc Q44073173 . . .
8. Calculate the discount amount for this order in F25. If theorder subtotal is more than $100, there will be a 15% discountapplied. This discount percentage can be found in cell B26. Hint:Use an IF function that tests whether the Order Subtotal (in F24)is greater than 100. If it is, return the value of the OrderSubtotal multiplied by the Discount Percentage; otherwise, returnthe value 0 (zero).
9. Calculate the Discounted Total for this order in cell F26.Hint: Use a simple subtraction formula.
10. Display the correct Shipping Charge in cell F27, based onthe Shipping Method entered in F10 and the corresponding shippingcosts in F13:F14. Hint: Use an IF function to determine if theShipping Method (in F10) is equal to “Standard”. If it is, returnthe Standard shipping cost (from F13), otherwise return theOvernight shipping cost.
11. Calculate the Invoice Total in cell F29. Hint: This will bethe total of the Discounted Total and the Shipping Charge.
Can someone help me with these formulas?
AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffe.com Order #: Order Date: Shipping Method: Overnight 45676 1/27/20 8 Customer: Kevin Kemper 9 Address: 42700 Heron Way Portland, OR 97225 Phone: 503-779-1873 Fax: Email: edwinda.copeland@hmail.com Shipping Options Standard $5.99 Overnight $14.99 Qty Item Total Item # K56 GO3 B07 Description Dark Mocha K-Cups (12 pack) Decaf Dark Roast – Ground (1 lb. Dark Roast – Whole Bean (1 lb.) Chai Lattle K-Cups (12 pack) Unit Price 1 $ 10.99 3 $ 12.99 2 $ 13.99 3 $ 12.99 K52 25 Discount Percentage 26 15% (orders over $100) Order Subtotal Discount Discounted Total Shipping Charge Invoice Total Show transcribed image text AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffe.com Order #: Order Date: Shipping Method: Overnight 45676 1/27/20 8 Customer: Kevin Kemper 9 Address: 42700 Heron Way Portland, OR 97225 Phone: 503-779-1873 Fax: Email: edwinda.copeland@hmail.com Shipping Options Standard $5.99 Overnight $14.99 Qty Item Total Item # K56 GO3 B07 Description Dark Mocha K-Cups (12 pack) Decaf Dark Roast – Ground (1 lb. Dark Roast – Whole Bean (1 lb.) Chai Lattle K-Cups (12 pack) Unit Price 1 $ 10.99 3 $ 12.99 2 $ 13.99 3 $ 12.99 K52 25 Discount Percentage 26 15% (orders over $100) Order Subtotal Discount Discounted Total Shipping Charge Invoice Total
Expert Answer
Answer to 8. Calculate the discount amount for this order in F25. If the order subtotal is more than $100, there will be a 15% dis…
OR