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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting #DIV/0 value using ISERROR
Does this help?
=IF(ISERROR(B3/C3),"",B3/C3) Mike "ConfusedNHouston" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting #DIV/0 value using ISERROR
Probably:
=IF(ISERROR(E5/F5),0,E5/F5) But you could just use: =IF(F5=0,0,E5/F5) Regards Trevor "ConfusedNHouston" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Overwriting #DIV/0 value using ISERROR
It might have been:
=if(iserror(e5/f5),0,e5/f5) or if e5 and f5 are always numbers (that may be 0): =if(f5=0,0,e5/f5) ConfusedNHouston wrote: 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 -- Dave Peterson |
Reply |
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) |