clear the error

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

hi,

i wrote a formula on range from a1 to e13, the result would be shown on
k1:k13 but the cell were shown on the #DIV/0! because i knew that the some
cell has not yet put the data. I really know how to clean it or replace by
0.

please help

thanks
jimmy
 
Basically

=IF(ISERROR(formula),"",formula)

but you can be smarter if you just test the cells that constitute the
dividend for 0.
 
Or divisor <bg>.

=if(bottomportionofexpression=0,"",wholeexpression)

And example for the OP.

Instead of:
=sum(a1:c99)/sum(q3:r6)

=if(sum(q3:r6)=0,"",sum(a1:c99)/sum(q3:r6))
 
Back
Top