Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ISERROR
ISERROR checks whether a value or formula result is any kind of error, returning TRUE for all error types including #N/A. It is frequently paired with IF to suppress error display or to provide fallback values when lookups or calculations fail.
Excel
=ISERROR(A2/B2)Google Sheets
=ISERROR(A2/B2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Numerator | Divisor | IsError? |
| 10 | 2 | FALSE |
| 5 | 0 | TRUE |
| 8 | 4 | FALSE |
=ISERROR(A2/B2)→FALSE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Wrap the formula or cell reference you want to test inside ISERROR (e.g., ISERROR(A2/B2)).
- 2The function returns TRUE for any error value and FALSE for valid results.
- 3Use =IF(ISERROR(VLOOKUP(...)),"Not found",VLOOKUP(...)) to provide a safe fallback instead of showing an error.
Need a version for your data?
Try: “Hide division errors in my calculation column and show zero instead”