ISERROR function

Returns TRUE if the value of cellreference is any error type; otherwise, it returns FALSE. The ISERROR function is used in formulas that refer to another cell.

Syntax

ISERROR(cellreference)

Example 1

Cell	Formula	Value returned
Scratch.A1	=NA( )	#N/A!
Scratch.B1	=ISERROR(Scratch.A1)	TRUE

Returns TRUE because the #N/A! error is recognized by the ISERROR function. You can use ISERR to find all types but the #N/A! error.

Example 2

Cell	Formula	Value returned
Scratch.X1	="House"	#VALUE!
Scratch.B1	=ISERR(Scratch.X1)	TRUE

Returns TRUE because the #VALUE! error is recognized by the ISERROR function. To build an expression based on the #VALUE! error, use the ISERRVALUE function.