Forum Discussion
Solved
Trying to find the average of two cells and, when the answer is zero not get #DIV/0
I am trying to calculate an average, D4/A4, and when the answer is 0.00 to get that to display instead of #DIV/0 in the cell. Thanks in advance. Sample: 1 $ 5.00 $ 2.00 ...
- You would use this formula, in case there is an error put 0
=IFERROR(D1/A1,0)
You would use this formula, in case there is an error put 0
=IFERROR(D1/A1,0)
=IFERROR(D1/A1,0)
- That did it! Thank you very much. Much gratitude!!
- You are welcome
I am glad that it helps you
