| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dealing with errors
Does anyone know whether there is a neat way to deal with a formula
whose result may be "error" without using the "iserror" function and effectively having to write the formula twice. For example, the construct I use currently is =IF(ISERROR(my formula),"n/a",my formula). This requires me to enter my formula twice which is redundant. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Open Excel getting error: EXCEL.exe has generated errors .. | Excel Discussion (Misc queries) | |||
| Shared sheet errors | Excel Discussion (Misc queries) | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| Errors accessing shared speadsheet. | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Threaded Mode
