hiding error message
 

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
--
Shooter

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
--
Shooter
.

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

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
--
Shooter
.

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



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

"Jason Morin" wrote:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
--
Shooter
.