Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 . |
#3
|
|||
|
|||
....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 . |
#4
|
|||
|
|||
=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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Worksheets | Setting up and Configuration of Excel | |||
Hiding info | New Users to Excel | |||
Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Hiding rows based on date | Excel Worksheet Functions |