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