hiding error message

[Shooter]

Can you please remind me how to hide or eliminate error messages such as
#DIV/0!. This appears when a cell is divided by 0. I would like the cell to
remain blank.

Thanks

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

 

[Brian]

....thanks, but I believe there is a way to "disable" the error message.
Thanks for additional assistance.

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

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

=IF(ISERROR(cell_that_might_return_error),"",cell_that_might_return_error)

although it's better to correct the faulty formula that returns the error
just like Jason showed

--
Regards,

Peo Sjoblom

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

...thanks, but I believe there is a way to "disable" the error message.
Thanks for additional assistance.