# ISERR function in Excel

> ISERR returns TRUE for any error except #N/A.

Source: https://spreadsheetpractice.com/functions/iserr · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISERR returns TRUE for any error except #N/A.
- **Syntax:** `=ISERR(value)`
- **Most common use:** `=ISERR(MATCH("Gizmo",A2:A5,0))` returns FALSE (FALSE: a missing product is #N/A, which ISERR ignores)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE for every error except #N/A, such as #VALUE!, #REF! or #DIV/0!. FALSE for #N/A and for every value that isn't an error.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISERR returns TRUE for any error except #N/A. That makes it the right test when "not found" is an expected, meaningful result, but a #DIV/0! or #VALUE! means the data is bad and should be flagged.

## Syntax

`=ISERR(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The value, cell or formula to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=ISERR(MATCH("Gizmo",A2:A5,0))` | FALSE | FALSE: a missing product is #N/A, which ISERR ignores |
| F2 | `=ISERR(B2/C2)` | TRUE | TRUE: zero units gives #DIV/0! |
| G2 | `=IF(ISERR(B4/C4),"Bad data",B4/C4)` | Bad data | Text in the units column is flagged |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Product | Revenue | Units |  | Gizmo lookup | Lamp per unit | Hub data check |
| 2 | Desk lamp | 1872 | 0 |  | FALSE | TRUE | Bad data |
| 3 | Monitor arm | 1958 | 22 |  |  |  |  |
| 4 | USB hub | 1769 | n/a |  |  |  |  |
| 5 | Webcam | 1173 | 17 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| A missing item isn't flagged | ISERR is FALSE for #N/A on purpose. Use ISERROR or ISNA if a failed lookup should be caught. |
| The calculation runs twice | IF(ISERR(x),"",x) calculates x twice. In a long formula, =LET(v,x,IF(ISERR(v),"",v)) calculates it once. |

## Tips

- Pair it with ISNA for a three-way result: found, not found, or bad data.

## Related functions

- [ISERROR](https://spreadsheetpractice.com/functions/iserror): ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?.
- [ISNA](https://spreadsheetpractice.com/functions/isna): ISNA returns TRUE only for the #N/A error, the one MATCH, VLOOKUP and XLOOKUP return when a value isn't found.
- [IFERROR](https://spreadsheetpractice.com/functions/iferror): IFERROR returns a value you choose when a formula results in an error, and the formula's normal result otherwise.

## Questions

### What does ISERR do in Excel?

It returns TRUE when a value is an error other than #N/A, such as #DIV/0! or #VALUE!.

### When should I use ISERR instead of ISERROR?

When #N/A is an expected answer, such as an item that isn't in a lookup table, but any other error means the data is broken.

## Practice

A graded ISERR exercise ("Cost per attendee") is on [the ISERR page](https://spreadsheetpractice.com/functions/iserr). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
