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