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”
“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!
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.
Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
LARGE function is used to get the Largest k-th value from the range.
LARGE Function has two required arguments i.e. array, and k
Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…
AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.