Question: In cell F 2 7 , use an IF function to calculate the discount amount for this order based on the customer s status (

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.

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!

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

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

Q:

1. In cell f27, use an if function to calculate the discount amount for this order based on the customer's status (which is found in f16 says preferred). if the customer's status is preferred, the...

Q:

I'm trying to figure out how to get this function in Microsoft Excel right and it's not working. These are the Directions on the assignment In cell F27, use an IF function to calculate the discount...

Q:

In Microsoft excel I'm working on a paper and having trouble with the IF function, the question I have to figure out is this: I know how to do IF functions and have either True or False come back but...

Q:

Bennett Enterprises purchased 50,000 gallons of direct materials during the year at a price of $2.50 per gallon. Bennett's direct materials price variance was $5,000 F. Required Calculate the...

Q:

The file Property Taxes contains the property taxes per capita for the 50 states and the District of Columbia. a. Compute the mean, median, first quartile, and third quartile. b. Compute the range,...

Q:

Background Chapter 2 2 Homework Task For this homework, your task is to calculate 2 0 2 4 ending stock basis for Alyssa, Jordan, Michele, and Jerry. To do this, first calculate the initial stock...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

Within the White-Collar Occupations, where do Females have the strongest and weakest representations in the Federal Service?

Q:

What are the Five Phases of SDLC? Explain each briefly.

Q:

How can Change Control Procedures manage Project Creep?