Syntax
=ISERROR(value)
value- The value or formula to check.
ISERROR function in Google Sheets
ISERROR returns TRUE if a value is any kind of error (#N/A, #DIV/0!, #VALUE!, #REF!, #NUM!…). It's useful for flagging problem rows without replacing the error.
Practice ISERROR
Task 1 of 1
Flag rows where dividing revenue by units would cause an error. Return TRUE/FALSE in C2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
ISERROR examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | |
|---|---|---|
| 1 | Value | Other |
| 2 | -7.45 | 3 |
| 3 | 12.5 | 4 |
| 4 | 81 | 2 |
| 5 | 2.5 | 0 |
| 6 | 1234.567 | 5 |
| Formula | Result | What it shows |
|---|---|---|
=ISERROR(A5 / B5) | TRUE | Dividing by zero is an error. |
=ISERROR(A3 / B3) | FALSE | This one is fine. |
=ISERROR(SQRT(A2)) | TRUE | Square root of a negative is #NUM!. |
Tips and common mistakes
- If you want to replace the error rather than flag it, use IFERROR.
Related functions
Learning step by step? ISERROR is covered in Lesson 10: ISBLANK, ISNUMBER & IS Functions of the free course.