How to use Excel ISERR Function – An Introduction

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.


Excel IsErr Function


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

ISERROR Function

ISTEXT Function  

ISLOGICAL Function  


Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.