#DIV/0!

C

Cindy Conover

I have a Fuel tax log that is broken down by states. If I do not fuel in a
state that has mileage i receive the error #DIV/0!. I know why I have this,
I was just wondering if there is a format to blank this error. I tried
setting my Display cell errors to blank but that did not help.

TIA
Cindy
 
J

JE McGimpsey

I really don't recommed that approach (though it certainly works) - it
will mask other errors besides #DIV/0 (e.g. #VALUE!), potentially
incorrectly affecting the logic of the worksheet, and giving the user a
false sense of security.

In general, it's better to handle "expected" errors as narrowly as
possible so that "actual" errors are still flagged as errors.
 
J

joeu2004

I have a Fuel tax log that is broken down by states. If I do not fuel in a
state that has mileage i receive the error #DIV/0!. I know why I have this,
I was just wondering if there is a format to blank this error. I tried
setting my Display cell errors to blank but that did not help.

You asked about a __format__ that would display the error as blank. I
don't know of any. But even if a format trick does exist, I would not
recommend using it. Even if the cell that displays #DIV/0 is a
"terminal" cell currently (no cell depends on it), worksheets have a
tendency to evolve over time. If you mask an error value with a
format, the value is still there. The error value will propagate into
dependent cells later. Besides being a pain to work around then, it
will probably confuse you because will have long-since forgotten that
you have hidden errors with a format.

If it is better to avoid computational "errors" by changing your
formula, as others have suggested in this thread.
 

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

Top