Practice free

ISERR function

ISERR returns TRUE for any error value except #N/A, and FALSE for everything else, including #N/A. Use ISERROR if you want #N/A to count as an error too.

Example

Read it as a sentence: check whether F11 holds an error other than #N/A, which gives FALSE.

Practice this in the app

Syntax

ISERR(value)

value (required)
The value to check.

Returns: TRUE for any error except #N/A.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ISERR(NA()) FALSE N/A
=ISERR(1/0) TRUE Div 0
=ISERR(5) FALSE Value
=ISERR(Data!F11) FALSE N/A cell
=ISERR(Data!F5:F6) TRUE Range spills

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • #N/A returns FALSE here.

Where it works

Excel
ISERR is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .