What is IFERROR Function in MS Excel?
The IFERROR function in MS Excel is used to find the errors in formulas. If there is an error in the formula, the IFERROR function will help to return the error value. However, it returns the value of the formula if there is no error.
Purpose of IFERROR Function in Excel
It is used to get a result in case any formula in Excel generates an error. However, the return value of the formula is given as a result if there is no error. This function is very helpful in tracking and managing errors in Excel formulas. There is no need to use complex nested IF statements when you use the IFERROR function. This is actually an upgraded form of the ISERROR function.
Syntax of IFERROR Function
The syntax of the IFERROR function in Excel is written as follows.
=IFERROR (value, value_if_error)
There are only two arguments in this function that are described below.
Value: this is the value or reference of the formula which has to be checked for errors.
Value_if_error: this is the value that will be returned in case some error is found.
=IFERROR (C5/D5, 0)
The above example will give the result of C5/D5. However, it will return 0 in case of an error.