What Is the use of Excel IFERROR Function
Use Excel IFERROR Function to test the error & replace that error with as a meaningful result. Excel IFERROR Function can be your best friend if you are in fear of errors.
It was first introduced in the Excel 2007. Most of the times IFERROR is used with other formulas to test their errors & replace them.
Syntax For IFERROR
value Refer to the value or cell from which you want to test the error.
value_if_error Value which you wants to get in return when an error occurs in value.
More Information To Use IFERROR in excel
- IFERROR Function is concerned with the occurrence of an error not with the type of the error which occurred.
- If you skip specifying value or value_if_error, if will return 0 in the result.
- It can test #N/A, #REF!, #DIV/0!, #VALUE!, #NUM!, #NAME?, and #NULL!.
- If you are evaluating an array it would return an array of results for each item in the range specified in value.
Examples To Understand IFERROR
In above example, I have used the IFERROR Function to replace the #DIV/0! with some meaningful text. As 10/0 has returned an error & IFERROR Function has replaced that error.
IFERROR Function is only compatible with 2007 & earlier versions. To deal with this problem, you can use EXCEL ISERROR Function.
Download Sample File
Excel IFERROR Function is one of the most useful functions in excel & used in Mega Function to test the errors. Learn more about AND from here.