Forum Discussion

Brass Contributor

Nov 19, 2020

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

excel

Formulas and Functions

Ilgar_Zarbaliyev
Nov 19, 2020
Michael1105

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")

MichaelAntonelli_If_Expresion - Copy.xlsx9 KB

SergeiBaklan

Diamond Contributor

Nov 20, 2020

Michael1105

Why do we need IF within?

=IFERROR(AVERAGE($H$15:$H15),"")

and drag down

Michael1105
Brass Contributor
Nov 20, 2020
SergeiBaklan Thank you so very much for your help and responding. 🙂