Replacing #DIV/0! With Just 0
 

Is there a way to replace #DIV/0! error message with just 0?

Replacing #DIV/0! With Just 0
 

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)

"Mike" wrote:

Is there a way to replace #DIV/0! error message with just 0?

Replacing #DIV/0! With Just 0
 

"Mike" wrote:
Is there a way to replace #DIV/0! error message
with just 0?

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().