Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In cell F17, enter an IF function that tests whether the order quantity in cell D17 is greater than 0 (zero). lf it is, return
In cell F17, enter an IF function that tests whether the order quantity in cell D17 is greater than 0 (zero). lf it is, return the value of the Qty (in D17) multiplied by the Unit Price (in E17); otherwise, return no text by entering (2 quotation marks). Will someone give me the formula for this question?
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 TotalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started