Numerical error in IF-sentence

Is it possible to use a numerical error as a term in a logical test in a IF syntax?

Expressed in words:
Return 1 if cell A1 contains a numerical error, else return 0
Or in syntax IF(A1=#Numerical error;1;0)

Originally Posted by MnO

Is it possible to use a numerical error as a term in a logical test in a IF syntax?

Expressed in words:
Return 1 if cell A1 contains a numerical error, else return 0
Or in syntax IF(A1=#Numerical error;1;0)

What do you mean "numerical error"?

If you want to return 1 if A1 contains any error value

=ISERROR(A1)+0

you could also use ISERR to check for all error values other than #N/A, or ERROR.TYPE to check for specific errors