Question: please help with the formula needed for this question? 10. Jane wants to calculate the percentage each type of gift contributed to the total amount

please help with the formula needed for this question?

10. Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the calculation, she wants to make the calculation using the IFERROR function, which she has already entered. Complete the formula as follows: a. In cell C5, before the comma in the IFERROR function, create a formula without using a function that divides the amount of cash gifts (cell B5) by the total amount of gifts (cell B11). b. Use an absolute reference to cell B11 in the formula. c. Use the Fill Handle to fill the range C6:C10 with the formula in cell C5

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 Accounting Questions!

1. a. PROJECT STEPS Jane Bahr is a development officer at Cortona University, a private university in western Massachusetts. She is tracking the pledges received from donors in July and August and...

PROJECT STEPS 1 . Jane Bahr is a development officer at Cortona University, a private university in western Massachusetts. She is tracking the pledges received from donors in July and August and...

please provide the formaulas thank you 9. Go to the Quarter 3 Gifts worksheet. Apply the Accounting number format to the gift amounts (the range B5:B11) to indicate they are dollar amounts. 10. Jane...

9. Go to the Quarter 3 Gifts worksheet. Apply the Accounting number format to the gift amounts (the range B5:B11) to indicate they are dollar amounts. 10. Jane wants to calculate the percentage each...

Cortona University assigns each donation to a level of Gold, Silver, or Bronze depending on the pledge amount. Display the donation level using a nested IF function as follows: In cell H5, insert a...

What is the answer for this question... I already use this formula but it didn't work IFERROR(B5/$B$11,0%). Data Change the number format. Jane wants to calculate the percentage each type of gift...

Need help understanding how to correct my formulas based off the feedback to the instructions provided. I will list all the formulas I used that were marked as "incorrect. Please let me know if more...

Change the number format. Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the calculation, she wants to make the...

Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the calculation, she wants to make the calculation using the...

Discuss how a community in Pennsylvania is split by religious differences, the teaching of evolution and intelligent design. The debate fueled by the school board adopting a book which indicated...

Explain B-tree.

A pension fund manager is comsidering three mutual funds. The first is a stock fund, the sevond is a long term government and corporatw bond fund, and the third is a t bill money marker fund that...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

Technology. Your instructor has asked you to speak to the faculty club at your school. Your speech is to be about the benefits of membership in student organizations. You are unable to make the...

Seafood Specialties Restaurant offers a shrimp and lobster tail special each Friday evening.You are manager of the restaurant. On Tuesday, you received a request from a customer, Shipley Masters, who...

You are the customer service representative for Fly High Airline. The airline awards frequent flyer miles but charges a $50 fee per ticket unless the free flight is booked more than 14 days in...