How to Use the ISERROR Function in Excel
The ISERROR function in Excel and Google Sheets is utilized to determine whether a specified value qualifies as an error. It yields TRUE if an error is present, otherwise it returns FALSE.
Syntax
The syntax for the ISERROR function is:
ISERROR(value)Examples
Here are some practical examples of the ISERROR function in use:
Example 1: Checking if a Cell Contains an Error
In this example, we check if the content of cell A1 is an error using the ISERROR function:
| A | B |
|---|---|
| #DIV/0! | =ISERROR(A1) |
The formula in cell B1 returns TRUE, indicating an error in cell A1, specifically a #DIV/0! error.
Example 2: Using in an IF Statement
The ISERROR function can be embedded within an IF statement to provide a specific message depending on the presence of an error:
| A | B |
|---|---|
| #VALUE! | =IF(ISERROR(A1), “Error Found”, “No Error”) |
The formula in cell B1 outputs “Error Found” because cell A1 is afflicted with a #VALUE! error.
Example 3: Checking Multiple Cells
The ISERROR function can also evaluate multiple cells simultaneously. Here, we check cells A1 to A3 for any errors:
| A | B |
|---|---|
| #DIV/0! | =IF(ISERROR(A1:A3), “Error Found”, “No Error”) |
If any of the cells from A1 to A3 contain an error, the formula in cell B1 would display “Error Found”.
These examples illustrate how the ISERROR function can strategically be applied in Excel and Google Sheets to detect errors within cells and manage conditional outputs based on this detection.
More information: https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665