“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” 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.
“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)
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!
WORKDAY Function in Excel Are you working today? or Do you have Work Off or holiday today? I am asking this question because I am gonna tell you the most commonly used function in Excel…
How to use Excel Function PROPER? PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which makes the function…
Generate Random Numbers in Excel Using RAND We have got many instances where we needed to generate a random database or values. Rand function is very useful for the users who creates random database for…
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments