#DIV/0! (MsOffice 97 SR2)

Topic

New Reply

I know this has been asked before but can anyone tell me how to hide the #DIV/0! .

Thanks in advance.

Reply | Quote

Replies

Do some error checking in an IF:

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

or, more generic

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

Reply | Quote

>if you are a fool at forty, you will always be a fool.

Why didn’t someone tell me when I was 39?

-IF- the denominator will always be a number, not an #ERR, a slightly simpler way is to use the denominator as a Boolean argument to the IF, as in:

=IF(B1,A1/B1,)

Reply | Quote

John, very nice looking albeit cryptic! I always forget that zero is false.

Reply | Quote

I would like to thank you and anyone else who responded to this question.

Thanks

Reply | Quote