Learn How to Use Microsoft Excel ISERR Function

Microsoft Excel ISERR Function

The main function of the Microsoft Excel ISERR function is to test for the error function but #N/A. It implies with the help of the ISERR function you can able to get the return value as the TRUE if there is any error except #N/A. You can also use the ISERR function with the IF function to test for an error and display a custom message, and can also perform a different calculation if found.           

Return Value of ISERR Function

The return value will be the logical TRUE or FALSE.

Syntax of ISERR Function

=ISERR(value)

Where the arguments:

• value: It is the value to check any error except #N/A.

How to Use Microsoft Excel ISERR Function?

You can use the ISERR function to get the specific errors in a particular cell except for #N/A like - #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! etc. Usually, the value is supplied as a cell address. The ISERR function is a part of function groups called "IS" functions, which are usually used to test the result of the formulas.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel