Syntax

IFERROR(value,value_if_error)

Value     is the argument that is checked for an error.

Value_if_error     is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Remarks

• If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (“”).
• If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.

Syntax

ERROR.TYPE(error_val)

The ERROR.TYPE function syntax has the following arguments:

• Error_val    Required. The error value whose identifying number you want to find. Although error_val can be the actual error value, it will usually be a reference to a cell containing a formula that you want to test.

If error_val is	ERROR.TYPE returns
#NULL!	1
#DIV/0!	2
#VALUE!	3
#REF!	4
#NAME?	5
#NUM!	6
#N/A	7
#GETTING_DATA	8
Anything else	#N/A