#div/0

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

How do you get the #DIV/0 to not display in the cell. I
want to keep the forumula in that cell because it will
work at some point, so for now I would just like to know
how to make it so that error does not show..
 
Carlos,

The simple answer to this it to test for the zero before
calculating the formula.
Example:
=A1/B1 will give a #DIV/0 error if there's nothing in B1
sooooooo
=IF(B1=0,"",A1/B1)
will check fisrt to see if B1 is zero. If it is, it'll return a blank.
If it's not, it'll give you the result of your formula.

John
 
Back
Top