| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting #DIV/0 value using ISERROR
I have formulas in cells that return a #DIV/0 because there is no data to put
in dependent cells in the formula. Someone show me, apparently way too long ago, how to use ISERROR to cause the value to be "0" if an error was found and to be the output of the formula if no errors were found. It was something like =ISERROR(J5,0,E5/F5) but that's not working. I would appreciate some help with the syntax. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alert before overwriting cells | Excel Discussion (Misc queries) | |||
| Overwriting Duplicates in certain cases | New Users to Excel | |||
| Overwriting data | Excel Discussion (Misc queries) | |||
| Spreadsheets are overwriting each other | Excel Discussion (Misc queries) | |||
| Overwriting Cells | Excel Discussion (Misc queries) | |||
Threaded Mode
