Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ISERR
ISERR is similar to ISERROR but deliberately excludes #N/A, returning FALSE when the value is #N/A and TRUE for all other errors (#VALUE!, #REF!, #DIV/0!, #NAME?, #NUM!, #NULL!). Use it when #N/A has a distinct meaning (e.g., item not found) and you want to treat it differently from calculation errors.
Excel
=ISERR(A2)Google Sheets
=ISERR(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | IsErr? |
| Hello | FALSE |
| #VALUE! | TRUE |
| World | FALSE |
=ISERR(A2)→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
- 1Pass a cell or formula to ISERR (e.g., =ISERR(A2)).
- 2It returns TRUE for all errors except #N/A, and FALSE for #N/A and non-error values.
- 3Combine with IF to handle real errors separately: =IF(ISERR(formula),"Error",formula).
Need a version for your data?
Try: “Flag calculation errors in my sheet but leave #N/A values visible”