Replacing #DIV/0! With Just 0

J

James McDowell

I usually use the following for a formula

simple formula =a1/b1 can give you a number of errors. So I use
=if(iserror(a1/b1),0,a1/b1)
 
J

joeu2004

Mike said:
Is there a way to replace #DIV/0! error message
with just 0?
Click to expand...

Several ways. Among them:

=IF(denominator = 0, 0, expression)

=IF(ISERROR(expression), 0, expression)

=IF(ISERR(expression), 0, expression)

Use Help to see the difference between ISERROR()
and ISERR().
 
Top