Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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 Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David M. Kroenke

12th Edition International Edition

1292023422, 978-1292023427

More Books

Students also viewed these Databases questions