ID EN
…
#Information

ISERR

Excel Functions

Test for any error but #N/A

Syntax

EXCEL 
=ISERR(value)

Arguments

Parameter Description
value The value to check for any error but #N/A.

Return Value

A logical value (TRUE or FALSE)

Details

The ISERR function returns TRUE for any error type except the #N/A error. This includes #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!, #CALC!, and #SPILL! errors. The ISERR function takes one argument, value, which is typically a cell reference. ISERR will return TRUE if A1 contains any error except #N/A: You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if found. Excel provides a number of error-related functions, each with a different behavior:

Examples

Examples

ISERR will return TRUE if A1 contains any error except #N/A:

EXCEL 
=ISERR(A1) // TRUE if A1 contains an error
Examples

You can use the ISERR function together with the IF function to test for an error and display a custom message, or perform a different calculation if

EXCEL 
=IF(ISERR(A1),"custom message")

See Also

ISERROR ERROR.TYPE ISBLANK ISEVEN ISFORMULA ISLOGICAL ISNA ISNONTEXT