Divide by Zero

[JimS]

Hello
I have instances where a cell with a formula will have a divide by zero
value. This is displayed as #DIV/0.
How can I supress the display of that message (#DIV/0)?
Thanks!
JimS

 

[Frank Kabel]

Hi Jim
use something like
=IF(N(A1)=0,"",B1/A1)

 

[Peo Sjoblom]

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

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Sandy Mann]

Hi Jim
use something like
=IF(N(A1)=0,"",B1/A1)

or just

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

Sandy[/QUOTE]