| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to write a formula that will prevent appearance ERROR MESSAGE
I have a formula that sometimes brings error message as a result.
I like to suppress error message generation and substitute that with empty cell (for instance""). How in a single cell can I write a formula and in the same time prevent appearance on any king of error message as a result from the formula? Thank you in advance. |
|
#2
|
|||
|
|||
|
You can wrap your formula in an "IF" statement, depending on the type of
error message, such as =IF(ISERR(YourFormula),"",YourFormula) or =IF(ISNA(YourFormula),"",YourFormula) Vaya con Dios, Chuck, CABGx3 "Huriiii" wrote in message ... I have a formula that sometimes brings error message as a result. I like to suppress error message generation and substitute that with empty cell (for instance""). How in a single cell can I write a formula and in the same time prevent appearance on any king of error message as a result from the formula? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
