ERROR.TYPE
Description
ERROR.TYPE returns a number corresponding to an error.
Syntax
ERROR.TYPE ( error_ref )
|
Parameter |
Description |
|
error_ref |
A cell reference. |
Remarks
The following error text or numbers can be returned by this function.
|
Number |
Description |
|
1 |
#NULL! |
|
2 |
#DIV/0! |
|
3 |
#VALUE! |
|
4 |
#REF! |
|
5 |
#NAME? |
|
6 |
#NUM! |
|
7 |
#N/A |
|
#N/A |
Other |
Example
This function returns 2 if the formula in the A1 cell attempts to divide by zero:
ERROR.TYPE(A1)
Also, see