Excel ISERROR Function

Logic Function ยท Beginner Level

What is ISERROR?

Returns TRUE if the value is any error type. Broader than ISNA which only checks #N/A.

Syntax

=ISERROR(value)

Example

Formula: =ISERROR(A1)

Result: TRUE or FALSE

How It Works

Returns TRUE for any error: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, #NULL!. Use IFERROR for simpler handling.

Learn More Excel Functions