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 |