# ISERROR function in Excel

> ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?.

Source: https://spreadsheetpractice.com/functions/iserror · 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:** ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?.
- **Syntax:** `=ISERROR(value)`
- **Most common use:** `=IF(ISERROR(B3/C3),"No visits",B3/C3)` returns No visits (Zero visits would give #DIV/0!, so the text shows instead)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the value is any error, FALSE otherwise.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISERROR returns TRUE for any error value, such as #N/A, #VALUE!, #REF!, #DIV/0! or #NAME?. Use it to count or flag rows where a calculation failed. When you just want a fallback value, IFERROR does the same job in fewer keystrokes.

## Syntax

`=ISERROR(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 | `=IF(ISERROR(B3/C3),"No visits",B3/C3)` | No visits | Zero visits would give #DIV/0!, so the text shows instead |
| F2 | `=SUMPRODUCT(--ISERROR(B2:B5/C2:C5))` | 2 | Two rows fail: one divides by zero, one divides by text |
| G2 | `=IF(ISERROR(MATCH("Uptown",A2:A5,0)),"Not a store","Listed")` | Not a store | MATCH returns #N/A for a missing name |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Store | Sales | Visits |  | Airport per visit | Rows that fail | Uptown listed? |
| 2 | Downtown | 4200 | 350 |  | No visits | 2 | Not a store |
| 3 | Airport | 1800 | 0 |  |  |  |  |
| 4 | Mall | 3100 | n/a |  |  |  |  |
| 5 | Harbor | 2650 | 290 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| It hides problems you needed to see | ISERROR is TRUE for every error, including #REF! from a deleted column and #NAME? from a typo. Use ISNA when you only mean "not found". |
| The formula is written twice | IF(ISERROR(x),"",x) calculates x twice. IFERROR(x,"") gives the same result in one step. |

## Tips

- Highlight broken rows with conditional formatting: =ISERROR($D2).

## Related functions

- [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.
- [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.
- [ISERR](https://spreadsheetpractice.com/functions/iserr): ISERR returns TRUE for any error except #N/A.

## Questions

### What is the difference between ISERROR and IFERROR?

ISERROR only tests and returns TRUE or FALSE. IFERROR returns the value, or a fallback if it's an error, so it's shorter for the common case.

### What is the difference between ISERROR, ISERR and ISNA?

ISERROR catches every error. ISERR catches every error except #N/A. ISNA catches only #N/A.

### How do I count errors in a range?

=SUMPRODUCT(--ISERROR(D2:D50)) counts every cell in D2:D50 that holds an error.

## Practice

A graded ISERROR exercise ("Price per unit, safely") is on [the ISERROR page](https://spreadsheetpractice.com/functions/iserror). 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.
