## Quick Intro

Excel ISERR Function will tell you that if there is any error in a cell. Just like ISERROR Function, It will check about the error in cell excluding #N/A. In simple words, it will return TRUE if there is any error in the cell other than #N/A.

## Syntax

**ISERR(value)**

**value**A cell reference or a value from which you want to check the error.

## More Information on Excel ISERR Function

- ISERR will verify an error in both conditions, either that error is in an absolute value or is a result of another formula.
- Evaluate all types of error from a cell #DIV/0! #NAME? #NULL! #NUM! #REF! & #VALUE! but not #N/A. To check #N/A, you can use ISNA Function or ISERROR Function.

## Examples

In the below example, I have used ISERR With If Statement to get a specific text if there is any error in a cell.

In the below example, I have used ISERR With An Array Range to check the error from a range of cells.

You can also use this formula with other Excel Function to create some dynamic formulas.

## Sample File

## What’s Next?

To learn more about Excel ISERR Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISERROR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.

## Leave A Comment