ISERR Function - Excel
Overview
The ISERR function in Excel is a useful tool for checking if a cell contains any errors other than a “#N/A” error. This function will return a TRUE value if the specified cell contains any errors except for “#N/A” and it will return a FALSE value if the cell does not contain any errors.
Example:
=ISERR(C2)
Syntax:
=ISERR(value)
value: This is the value or reference to the cell you want to check for errors.
TRUE Example
In this example, the ISERR function gives us the TRUE value result because the C2 cell has a “#DIV/0!” error.
FALSE Example
In this example, the ISERR function gives us the FALSE value result because the C2 cell contains the value 5, which is not an error.
