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.
- 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.
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.
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.