1. In cell F19, enter an IF function that tests whether the order quantity in cell D19 is greater than 0 (zero). lf it is, return the value of the Qty (in D19) multiplied by the Unit Price (in E19); otherwise, return no text by entering .
2. Copy/fill this formula into the other cells in the range F19:F25. Hint: be sure to copy the formula to all of the Item Total cells, even if it is a blank row. You want the worksheet to be prepared for orders with more items in the future.
3. In cell F26, calculate the sum of all of the Item Total cells.
4. In cell F27, use an IF function to calculate the discount amount for this order based on the customers status (which is found in F16). If the customers status is Preferred, the discount amount will be the Order Subtotal times the discount percentage found in cell B29; otherwise the discount amount will be 0 (zero). Hint: You will need to use a formula for the Value if True argument.
5. Calculate the Discounted Total for this order in cell F28. Hint: Use a simple subtraction formula.
6. In cell F29, use an IF function to display the correct Shipping Charge, based on the amount of the Discounted Total. If the Discounted Total is greater than or equal to the Free Shipping Minimum found in cell B28, the Shipping Charge is 0 (zero); otherwise, the Shipping Charge is 5% of the Discounted Total. Hint: You will need to use a formula for the Value if False to calculate what 5% of the Discounted Total will be.
7. Calculate the Invoice Total in cell F31. Hint: This will be the total of the Discounted Total and the Shipping Charge.
8. Review the worksheet in Print Preview. Make any changes needed to make the worksheet print on one page.

AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffee.com Order #: 45676 Order Date: Shipping Information Customer: Address: Billing Information Customer: Edina Copeland Address: 4270 Heron Way Portland, OR 97225 Phone: 503-779-1873 Email: edina.copeland@hotmail.com Status: Preferred K56 Item # Description Dark Mocha K-Cups (12 pack) G03 Decaf Dark Roast-Ground (1 lb.) B07 Dark Roast - Whole Bean(1 tb.) K52 Chai Latte K-Cups (12 pack) Qty Unit Price Item Total 1 $ 10.99 12.99 3 13.99 N 3 12.99 Special Offers $200 Free Shipping Minimum 10% Preferred Customer Discount Order Subtotal Discount Discounted Total Shipping Charge Invoice Total AstroCoffee Company 2058 Hope Street, Suite 570 Portland, OR 97209 support@astrocoffee.com www.astrocoffee.com Order #: 45676 Order Date: Shipping Information Customer: Address: Billing Information Customer: Edina Copeland Address: 4270 Heron Way Portland, OR 97225 Phone: 503-779-1873 Email: edina.copeland@hotmail.com Status: Preferred K56 Item # Description Dark Mocha K-Cups (12 pack) G03 Decaf Dark Roast-Ground (1 lb.) B07 Dark Roast - Whole Bean(1 tb.) K52 Chai Latte K-Cups (12 pack) Qty Unit Price Item Total 1 $ 10.99 12.99 3 13.99 N 3 12.99 Special Offers $200 Free Shipping Minimum 10% Preferred Customer Discount Order Subtotal Discount Discounted Total Shipping Charge Invoice Total