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?
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.
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.