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

What is the answer for this question... I already use this formula but it didn't work

IFERROR(B5/$B$11,0%).What is the answer for this question... I already use this formulabut it didn't work IFERROR(B5/$B$11,0%). Data Change the number format. Jane wants

Data 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 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 B1 1 in the formula. c. Use the Fill Handle to fill the range C6:C10 with the formula in cell C5. Create a formula using a function. In the Quarter 3 Gifts worksheet, the formula in cell C5 should use the IFERROR function to avoid a divide by zero error in the calculation where the amount of cash gifts is divided by the total amount of gifts. Copy a formula into a range. In the Quarter 3 Gifts worksheet, cell C5 contains an incorrect formula

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!