Excel Function ISERROR
“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”
Excel Function ISERROR Advantages:-
“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
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)
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!
Secrets of Excel Data Visualization: Beginners to Advanced Course
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
Excel VBA Course : Beginners to Advanced
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Use Automated Excel Utility Tools to increase productivity
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community