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!
In this guide, you will learn how to use the NPV function in Excel to calculate the net present value of an investment and how to avoid common mistakes when using NPV in Excel.
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…
SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.
In this tutorial, you’ll learn what an Excel array formula is, how to enter it properly, and how to use array constants and array functions.
Array formulas are a very powerful tool in Excel, allowing you to do multiple calculations with a single formula. One array formula can replace many regular formulas. However, most users—around 90%—have never used them because they seem intimidating to learn.
Array formulas are known to be one of the trickiest Excel features to understand. The goal of this tutorial is to make learning them as easy and simple as possible
MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments
How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.