Edit

Share via

ISERR Function

  • Article

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

Syntax

ISERR(cellreference )

Parameters

Name Required/Optional Data Type Description
cellreference
Required
String
Reference to a cell.

Example 1

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

Returns FALSE because the #N/A! error is not recognized by the ISERR function. Use ISERROR to find all error types.

Example 2

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

Returns TRUE because the #VALUE! error is recognized by the ISERR function.