Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business
Are you a data enthusiast? Join us for a ride on your data and automate your stuffs

EXCEL FUNCTION – ISERROR

Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any Error or not.
“ISERROR Function” returns the output as “TRUE” or “FALSE”. If cell value contains any “ERROR” then function will return value as “TRUE” or if cell value does not have any error, then function output will be “FALSE”
“ISERROR Function” has only one argument i.e. (value) and it is easy to apply for validation of cell, it provides the output that is easy to understand i.e. “TRUE” and “FALSE”

 

Advantage of “ISERROR Function”:

“ISERROR Function” can be used in any type of databases or cells whether it is Numeric/Alpha (Strings) etc. which makes the function useful and advantageous. Applying the logical function manually (one by one) to validate if cell has any “ERROR” or “NON-ERROR” is very tedious and “ISERROR Function” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.

 

Where “ISERROR Function” can be used:

“ISERROR Function” is very useful and can be used in multiple situations. Like it can be used as follows:
– Large excel worksheet which has many formulas placed
– Or any other database where there is requirement of validation of cells if any of cell contains any “Error” or not then “ISERROR Function” can be used

Syntax:

=ISERROR(value)

Syntax Description:

value, argument is used to give the cell reference. It is the cell number that is to be checked for “ERROR”

Things to Remember:

We need to understand the function output. If cell contains any “ERROR” then output will be “TRUE” or if cells contains “NO ERROR” then output will be “FALSE”
ISERROR function will work with any of the excel errors such as #REF!, #N/A, #VALUE!, #DIV/0!, #NUM!, #NULL!, or #NAME?
Also ensure that correct cell reference is given otherwise function output and decisions may go wrong.

Example 1: Validation of Large excel Database

Suppose we have employee database where address fields need to be validated if any of cell contains any error. We can utilize this function as follows:

Syntax: = ISERROR(B2)

ISERROR Function

We can review the above results that cells “A2” and “B2” contains excel errors i.e. #REF! and #NA that is why the output in cell “B2” and “C2” are “TRUE”. Whereas cells “A4” to “A7” does not contains any errors that is why the output in cells “B4” to “B7” are “FALSE”

Likewise, we can apply the “ISERROR Function” whenever there is requirement of validation of “Errors”

Hope you liked. Happy Learning.
Don’t forget to leave your valuable comments!

Leave a Reply

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