Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 formulaStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started