ISERROR function
TRUE if the value is any error value.
Information
Where can you use it?
Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.
Scenario in the workbook
Flag any Excel error generated by a ratio calculation.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Value | Comparison |
| 7 | 10 | 2 |
| 8 | 5 | 5 |
| 9 | 1 | 0 |
Record 1
=ISERROR(A7/B7)Expected resultFALSE
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=ISERROR(A7/B7)Turkish Excel · tr-TR
=EHATALIYSA(A7/B7)Worked examples
Flag any Excel error generated by a ratio calculation.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A | B |
|---|---|---|
| 6 | Value | Comparison |
| 7 | 10 | 2 |
| 8 | 5 | 5 |
| 9 | 1 | 0 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =ISERROR(A7/B7) |
FALSE |
| Record 2 | =ISERROR(A8/B8) |
FALSE |
| Record 3 | =ISERROR(A9/B9) |
TRUE |