Skip to content

ISERROR

InformationExcel 2007

TRUE if the value is any error.

Syntax

ISERROR(value)

Examples

=SUMPRODUCT(--ISERROR(C2:C100))

→ count of error cells

Good to know

  • To act on an error, IFERROR is shorter than IF(ISERROR(...), ...).

Related functions

IFERRORISNAERROR.TYPE

More Information functions

CELLERROR.TYPEINFOISBLANKISERRISEVENISFORMULAISLOGICALISNAISNONTEXTISNUMBERISODD

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.