Unlike, IFERROR Excel ISERROR Function will tell you that if there is any error in a cell. And, if there is any error in the cell value it will return TRUE else it will return FALSE.
In simple words, it will verify the if there is any error in a cell. To use ISERROR just refer to the cell from where you want to verify the error.
value A cell reference or a value from which you want to check the error.
More Information on Excel ISERROR Function
- ISERROR will verify an error in both conditions, either that error is in an absolute value or is a result of another formula.
- It will evaluate all types of error from a cell. #N/A, #DIV/0!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!.
In the below example, I have used ISERROR with IF to get a specific text if there is any error in a cell.
In the below example, I have used ISERROR with an array range to check the error from a range of cells.
To learn more about Excel ISERROR 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.