Excel ISERR Function

What is ISERR Function in Excel?

The ISERR function is one of the Information functions of Excel.

It Checks whether a value is an error other than #N/A, and returns TRUE or FALSE.

We can find this function in Information category of insert function Tab.

How to use ISERR function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Information category.

5. Select ISERR function

6. Then select ok.

excel ISERR function

7. In the function arguments Tab you will see ISERR 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.

How to use ISERR function in excel

Examples of ISERR function in Excel

Examples of ISERR function in Excel

ISERR related functions

  • Use ISERROR function to check whether a value is an error, and returns TRUE or FALSE.
  • Use ERROR.TYPE function to return a number matching an error value.
  • Use ISBLANK function to Check whether a reference is to an empty cell, and returns TRUE or FALSE.

Leave a Reply

Your email address will not be published. Required fields are marked *