Divide by Zero

  • Thread starter Thread starter JimS
  • Start date Start date
J

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
 
=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)
 
Back
Top