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

Excel formula please WILL THUMBS UP FOR CORRECT AWNSER 2.1) Use

an IF function in cell E10 to calculate the price to charge

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 buy a dozen or more. In this case, they are charged $.40a donut. b. Refer to the appropriate price in cells C3 and (4 for your "value if true" and "value if_false" arguments. c. Use absolute and relative references when appropriate. (5) (2.2) Copy your formula in cell (E10) and paste it down to

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!

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

I need the formula please no one has been able to awnser this. I will give a thumbs up. 2.1 Use an IF function in cell E10 to calculate the price to charge per donut for order 1. a. Customer are...

3 . 3 You are interested in purchasing a home. You have been quoted monthly payments of $ 9 5 0 for a 3 0 year mortgage. Your original loan amount is $ 2 1 2 , 0 0 0 . What is the interest rate you...

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

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

Complete the table on the IF Function worksheet to help Beverly calculate her commission based on the 5 0 customers she helped this morning. 2 . 1 Use an IF function in cell E 1 0 to calculate the...

Select ? 2 Sensitivity Add - ins MyEducator MyEducator Tasks the 5 0 customers she helped this morning. 2 . 1 Use an IF function in cell E 1 0 to calculate the price to charge per donut for order 1 ....

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

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

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

Using the Lewis electron-dot notation, show explicitly the transfer of electrons in the following redox reaction. Glucose-6-phosphate + NADP + 6-Phosphoglucono-d-lactone + NADPH + H +

How can a well specified investment strategy facilitate the job of investment managers in managing portfolios?

One of the best selling items the Square Store offers sells for $ 1 4 . 1 9 a unit. The variable cost per unit is $ 6 . 6 6 and the carrying cost per unit is $ . 0 . 5 5 . The firm sells 5 , 9 0 2 of...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

3 What kinds of presentations do you think would work best as podcasts? What kinds would not work well? Are podcasts useful outside academia?

Consider your specific speech purposewhat are your objectives for your informative speech? Now consider what types of presentation aids might help you achieve your purpose. How might you use aids to...

2 Imagine that you have to give an informative speech about a sexual topic in front of your nursing class. How would you approach the subject? Would you handle it differently if you were speaking in...