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.
|