Forum Discussion

Michael1105's avatar
Michael1105
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's avatar
    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")

     

     

     

Michael1105's avatar
Michael1105
Brass Contributor
Nov 20, 2020

Ilgar_Zarbaliyev Thank you very much.  The second suggestion is exactly what I needed to fix the error.  The first wouldn't have worked with the results I needed because the monthly average that would result in a "blank" I cannot have averaged into the YTD Rolling Average.  The second takes into account that the Blank would not be counted into the calculation, and still clears the error.  

 

I appreciate your assistance with this.  You are a lifesaver!

Resources