Replace #DIV/0 error?

A

Alan

Hi -

I am using Excel 2002 and have a bunch of formulas that result in #DIV/0!.
I know why this happens and theris NOT a problem with the formula, it is
simply based on the fact that we are dividing by 0.
The error is quite irritating [and confusing to my bosses that dont
understand]. Is there a way to simply have the error default to 0 when the
#DIV/0! ?

Thank you !

Alan
 

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

Replace #DIV/0! 4
Macro to get rid of #DIV/0! 2
#DIV/0! ERROR 2
Find and Replace #DIV/0! 7
Conditional format for #DIV/0 2
getting #DIV/0! when calculating percentage 4
dividing by 0 error 6
how to remove #DIV/0! 7

Top