8. Calculate the discount amount for this order in F25. If the order subtotal is more than $100, there will be a 15% discount applied. 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 Order Subtotal multiplied by the Discount Percentage; otherwise, return the 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 on the Shipping Method entered in F10 and the corresponding shipping costs in F13:F14. Hint: Use an IF function to determine if the Shipping Method (in F10) is equal to Standard. If it is, return the Standard shipping cost (from F13), otherwise return the Overnight shipping cost.

11. Calculate the Invoice Total in cell F29. Hint: This will be the 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