Look in HELP under ERROR.TYPE function.
If an error occurs
=ERROR.TYPE(A1) for #N/A = 7, and for #REF = 4
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"F. Lawrence Kulchar" wrote:

FLKulchar
In cell A1, I have either #N/A or #REF because, there 'was' an error in my
formula!

How come...=IF(A1="N/A", 3,4) does NOT work?

How can I make it to work...in other words, if cell A1 has a #N/A in it, how
can I make the 'IF' formula work???

Same is true for the "#REF" error!!

Please help.
FLKulchar