Replacing #DIV/0! With Just 0

  • Thread starter Thread starter Guest
  • Start date Start date
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 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().
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Supress DIV/0 2
Taking Average ignoring #DIV/0! in the range... 1
#DIV/0! error with DAVERAGE Function 5
Find and Replace #DIV/0! 7
Get rid of DIV/0 error message 4
How to calculate with #div/0! error? 12
how to remove #DIV/0! 7
dividing by 0 error 6

Back
Top