ISERR Function

Excel Functions › Information

All versions Information

The Excel ISERR function tests whether a value is any error except #N/A. It returns TRUE or FALSE, making it the building block of error-proof formulas, validation, and conditional logic.

Quick answer: test a cell:
=ISERR(A2) // TRUE when the value is an error other than #N/A

Syntax

=ISERR(value)
ArgumentDescription
valueRequiredThe value, cell, or expression to test.

How to use it

ISERR returns TRUE when the value is an error other than #N/A, and FALSE otherwise. Wrap it in IF to act on the result, or sum it with SUMPRODUCT to count matches: =SUMPRODUCT(--ISERR(A2:A100)).

The IS family: ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR, ISERROR, ISNA, ISREF, ISFORMULA, ISEVEN, and ISODD each return TRUE or FALSE so you can branch with IF, count with SUMPRODUCT, or drive conditional formatting.

Try it: interactive demo

Live demo

Pick an input and watch the formula and result update.

Result:

Practice workbook

📊
Download the free ISERR practice workbook
Every example on this page, ready to open in Excel — plus practice challenges with answers on a separate tab. No sign-up required.

Frequently asked questions

Why exclude #N/A?
#N/A often means “legitimately not found” rather than a broken formula. ISERR lets that pass while catching real errors.
How do I act on the TRUE/FALSE result?
Wrap it in IF: =IF(ISERR(A2), "yes", "no").
Can I count how many cells pass?
Yes: =SUMPRODUCT(--ISERR(range)) counts the TRUEs.

Master functions like this in one day

This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related functions: ISERROR · ISNUMBER · ISBLANK · IFERROR · NA