Excel ISERR Function checks the value in a cell, apart from #N/A, if a cell has any of the following errors like – #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? and #NULL!, it will return TRUE otherwise FALSE. This function is a member of IS group of functions in Microsoft Excel.

### Why we use Excel ISERR Function?

This function checks a cell value for error or not.

### What is the syntax for ISERR?

=ISERR (value)

### Parameters or Arguments

Value (required) – cell value, whether an error or not.

### What it returns as a result?

This is a logical function and always returns TRUE or FALSE as results.

**Important note:**

This function will not return TRUE for #/N/A error. If there is any situation where we got #N/A error, in that case, use **ISERROR Function** instead of ISERR.

Numeric and text values in a cell, will not consider as an error and this function will return FALSE as a result.

**See in the below image, for all kind of errors returns the result as TRUE or FALSE.**

This function is very similar to Excel **ISERROR Function**.

In the above image, cell “A10” has value “10/0” and our result with ISERR is TRUE. Because if we divide any number with zero (0) value, it will return an error code as #DIV/o!

In the above image, we can see that result of “#N/A” error code as FASE. The Excel ISERR Function cannot read this function and return a result as not an error.

If face this situation, use Excel ISERROR Function, this function can read all type errors values and return as TRUE.

Related Post