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")
You will need to apply an IFERROR function to the start of your formula.
Although the IF statement is correct, excel registers the BLANK as "" and not as an integer, which is why the >=0 returns an error.
You're adjusted formula would be
=IFERROR(IF(AVERAGE(....""),)