Forum Discussion
Solved
Need Help on stopping the #DIV/0! error.
I am at my wits end. I have been trying to get this to work for hours. What I need is to have cell I15 evaluate cell H15. If H15 has a value equal to or greater than 0.00 then to calculate the...
Hi there,
There are two ways to solve this problem.
1 - You must change blank cell into 0. = =IF(AVERAGE(A2>=0),AVERAGE(A2), "")
In this case your formula will work perfect.
2 - If you don't want to change, then use Iferror function. - =IFERROR(IF(AVERAGE(A2>=0),AVERAGE(A2), ""),"0")
Your tests are based upon the AVERAGE to date but you should not be testing against 0, you should be testing for an error using ISERROR or ISNUMBER. Better, base the test on the COUNT
= IF( COUNT(ValuesToDate), AVERAGE(ValuesToDate), "" )
- I appreciate your help and time in responding. I appreciate it very much 🙂
