It depends on what exactly you want.

If you want to test A1 for *any error*:

=IF(ISERROR(A1),3,4)

If you want to test for #N/A:

=IF(ISNA(A1),3,4)

If you want to test for #REF!:

=IF(ISNA((ERROR.TYPE(A1)=4)),4,3)

--
Biff
Microsoft Excel MVP


"F. Lawrence Kulchar" wrote in
message ...
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