Question: Use an IF function in cell E 1 8 to calculate the price to charge per donut for order 1 . A customer is charged

Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A
customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are
charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your
"value if true" and "value if_false" arguments. Use absolute and relative references when
appropriate.

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 General Management Questions!

Q:

a . C stomer are charged $ . 5 0 per di lut unless they buy a dozen or iore. In this case, they are che red $ . 4 0 a dont b . Refe ne appropriate price in cells C 3 ) and C 4 ) for your "value _ if...

Q:

Pleeeasseeee help me with the 5 questions below. This is my 5th time posting it on chegg and I just need to know how to answer these questions (what the formulas are) so that I can apply them to my...

Q:

please answer the questions using the cells from the excel provided Beverly sells donuts for $.50 each at the local bakery. If a customer buys at least a dozen donuts, the cost is reduced $.40 each....

Q:

do 2.1-2.7 Beverly seits denuts for 5.5 each at ine ioes bakery. if a custemer buja at feas a dozen Gowuts, the cojr is festuced 5.40 ach. EPvorly elarns a cormmsish bateed on the numbetr of donat...

Q:

B C D E G H J L M M N P Q R S T U V W Y Z AA AB AC AE AF AG AH Al AJ AK X Price Per Donut 0-11 $0.50 12 $0.40 Total Sales Total Commissi MyEducator Tasks $217.55 $0.00 1 2 3 4 3 6 7 3 Commission...

Q:

Atlas 3 . 0 morning. 2 . 1 Use an IF function in cell E 1 0 ) to calculate the price to charge per donut for order 1 . a . Customer are charged $ . 5 0 per donut unless they buy a dozen or more. In...

Q:

2 . 1 Use an IF function in cell E 1 0 ) to calculate the price to charge per donut for order 1 . a . Customer are charged $ . 5 0 per donut unless they buy a dozen or more. In this case, they are...

Q:

Nobody can get this right they jeep giving me the wrong cell references please help will thumbs up I've posted this question already. I need the Excell formula for this. 2.1) Use an IF function in...

Q:

Excel formula please WILL THUMBS UP FOR CORRECT AWNSER 2.1) Use an IF function in cell E10 to calculate the price to charge per donut for order 1. a. Customer are charged $.50 per donut unless they...

Q:

Please provide formulas 1 1 Use a VLOOKUP function in cell F25 of the CatastropheCoverageLowActivity worksheet to determine the appropriate Copayment for the first visit to a Primary Doctor. The...

Q:

Calculate the percent loss in weight after complete decomposition of a pure sample of potassium chlorate. KClO3(s)KCl(s) + O(g)

Q:

Which of the following statements about the minimum variance portfolio of all risky securities are valid? (Assume short sales are allowed.) Explain. a. Its variance must be lower than those of all...

Q:

Dividends on variable - rate preferred stock are adjusted to match the yield on short - term bond issues. changes in the going yield on equivalent securities . discount rate issued by the Fed. latest...

Q:

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...