What is ISERROR function in Excel?
The ISERROR function is one of the Information functions of Excel.
It Checks whether a value is an error, and returns TRUE or FALSE.
We can find this function in Information of insert function Tab.
How to use ISERROR function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Information category.
5. Select ISERROR function
6. Then select ok.
7. In the function arguments Tab you will see ISERROR function.
8. Value section is the value you want to test. Value can refer to a cell, a formula, or a name that refers to a cell, formula, or value.
9. You will see the results in the formula result section.
Examples of ISERROR function in Excel
ISERROR related functions
- Use ISERR function to check whether a value is an error and returns TRUE or FALSE.
- ISNA function
- Use ERROR.TYPE function to return a number matching an error value.
- IFNA function
