Question: 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 Total

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

COPY AND PASTE THIS EXACT SPREADSHEET BELOW INTO EXCEL THE CELL NUMBERS WILL BECOME CLEAR AS IT IS IN EXCEL Use the SC3 Data workbook below and save the workbook as SC3 AstroCoffee . Enter the...

stroCoffee: Cynthia McHenry owns a coffee supply company named AstroCoffee. She needs some help writing the formulas for the order form she uses to invoice customers. You will need to write the...

AstroCoffee Company AstroCoffee: Cynthia McHenry owns a coffee supply company named AstroCoffee. She needs some help writing the formulas for the order form she uses to invoice customers. You will...

Ruth Kobran owns a coffee supply company named MidasCoffee. She needs some help writing the formulas for the order form she uses to invoice customers. You will need to write the formulas for all of...

CAN U CHECK THIS HOMEWORK FOR ME, especially the discount amount, subtotal, discount total, and shipping charge. https://1drv.ms/x/c/8bf82ce5e9680020/EcI1yWNYQV9EoYie8m1M2IAB2BfG5JUSVg_ejJZLiJmPVA...

Enter the following order information: Order #: 45676 Order Date: use a function that displays the current date Enter the following Billing Information: Edwina Copeland 4270 Heron Way Portland, OR...

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);...

Unit 4 Assignment Start Assignment Due Sundayby11:59pm Points 100 Submitting a file upload Available Sep 6 at 12am - Sep 12 at 11:59pm7 days AstroCoffee Company AstroCoffee: Cynthia McHenry owns a...

I can not figure out how to come up with this IF formula in Microsoft Excel can someone please help me and show me how it's suppose to look??? I know how to make it say True or False but can't figure...

An L-R.C series circuit consists of a source with voltage amplitude 120 V and angular frequency 50.0 radls, a resistor with R = 400 an inductor with L = 9.00 H, and a capacitor with capacitance C....

Use the fact that det -7 -2 -5 6 1 -7 4 7 -7 - = 171 to compute the determinant of 10 0 1 18 0 BARR 01 0 0 1 0 0 2 0 0 1 6 7 [(-43,-91,65),(-2,-5,4),(-12,-14,14)] x Invalid use of a comma.syntax inc...

Work with one or more other learners on this question. You learnt about the number (pi) in Unit 8. It is the ratio of the circumference of a circle to its diameter. The value of is a decimal that...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

(Appendices) Describe the difference between F.O.B. shipping point and F.O.B. destination. LO56

(Appendices) What are sales returns? Why do sales returns occur? LO86

(Appendices) What are the components of cost of goods available for sale and of cost of goods sold? Assume that the firm uses the gross method of recording purchase discounts. LO45