#DIV/0!

[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

 

[JE McGimpsey]

One way:

If your formula is

=A1/B1

then

=IF(B1=0,"",A1/B1)

 

[avilliers]

One way:

If your formula is

=A1/B1

then

=IF(B1=0,"",A1/B1)




- Show quoted text -

Another way:

=IF(ISERROR(A1/B1),"",A1/B1)

 

[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.

 

[Cindy Conover]

That is my formula. And it works great. Thanks so much for the help.

 

[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.