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

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
Get step-by-step solutions from verified subject matter experts
