View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
okey okey is offline
external usenet poster
 
Posts: 7
Default validating references; how to recognize the #REF! condition

I'm hacking on this. This seems a little verbose and requires, I
think, that the formula execute twice. But what about this:

=if(iserror(_formula_here_), 0, _formula_here_)

If that is a good solution, then the next step is to bold that 0 so
that the user knows it artificial.