View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
 
Posts: 41
Default 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