Replacing "#DIV/0!"

[I. Woo]

How do we replace "#DIV/0!" with a numeric zero in a
worksheet?

Thx!

 

[Jason Morin]

You're dividing by zero. Counteract that by modifying the
formula you're using. A simple example would be:

=IF(A1=0,0,B1/A1)

or trap the error:

=IF(ISERROR(your_formula),0,your_formula)

HTH
Jason
Atlanta, GA