What it does
ISERROR does not tell you the result of the calculation, only whether it is an error: =ISERROR(B2/C2) returns TRUE when C2 is zero. That lets you flag faulty rows in a check column, filter them or count them.
In older versions, the pattern =IF(ISERROR(B2/C2),0,B2/C2) was used to show another value instead of an error; it is long because the formula is written twice. Today IFERROR does the same in one go: =IFERROR(B2/C2,0).
To test only for #N/A use ISNA; to test for every error except #N/A use ISERR. When different error types need different handling, these are more selective than ISERROR.
Syntax
=ISERROR(value)=EHATALIYSA(değer)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
value | Required | The value or formula to test, e.g. B2/C2 or MATCH(A2,$D$2:$D$5,0). |
Examples
1Flag rows where the calculation fails
Unit cost is total cost divided by quantity. The error arises inside the formula: the eraser's quantity is 0 and the stapler's was typed as words. Column D tests for the error; column E shows a warning on faulty rows and the cost on the others.
=ISERROR(B2/C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Total Cost | Qty | Error? | Unit Cost |
| 2 | Notebook | 4,800.00 | 120 | FALSE | 40.00 |
| 3 | Eraser | 1,250.00 | 0 | TRUE | Check |
| 4 | Binder | 3,150.00 | 90 | FALSE | 35.00 |
| 5 | Stapler | 2,640.00 | forty-eight | TRUE | Check |
- D2 (filled down to D5)
=ISERROR(B2/C2) - E2 (filled down to E5)
=IF(ISERROR(B2/C2),"Check",B2/C2)
The eraser's division gives #DIV/0! and the stapler's #VALUE!; ISERROR returns TRUE for both. Column E shows Check on those rows and the cost on the others: 40.00 for the notebook.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Find order codes missing from the price list
When MATCH cannot find a code in the price list (column D) it returns #N/A; ISERROR turns that into TRUE.
=ISERROR(MATCH(A2,$D$2:$D$5,0))| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order Code | Not in List | Price List | |
| 2 | KR-110 | FALSE | KR-110 | |
| 3 | KR-135 | TRUE | KR-120 | |
| 4 | KR-120 | FALSE | KR-130 | |
| 5 | KR-190 | TRUE | KR-150 |
- B2 (filled down to B5)
=ISERROR(MATCH(A2,$D$2:$D$5,0))
KR-135 and KR-190 are not in the price list, so they give TRUE; KR-110, which is listed, gives FALSE. ISNA is more selective for this job: it counts only the not-found error.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Always FALSE
Cause: The inner formula already catches the error with IFERROR, so the value reaching ISERROR is no longer an error.
Fix: Apply the test to the inner formula without IFERROR.
- Error types lumped together
Cause: ISERROR treats every error the same; a #NAME? from a typo returns TRUE just like a code that is not found.
Fix: Use ISNA for lookups that find nothing and look into other errors separately.
Good to know
- To count the error results in a column:
=SUMPRODUCT(--ISERROR(D2:D9)). - To put a word in the check column instead of TRUE/FALSE, wrap it in IF:
=IF(ISERROR(B2/C2),"Check","").
In Nexell
Get Nexell to do it from a sentence
Add a Check column to my unit cost table that says "Check" on rows where the calculation returns an error
Convert to tableBring your table into the tool and type this. Nexell adds the Check column with real Excel formulas and the preview shows which rows were flagged; in the downloaded file, the flag clears by itself once you fix the data.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month