ERROR.TYPE
Syntax:
ERROR.TYPE ( value )
Description: Determines the kind of the error value designated by value.
Arguments:
Name |
Type |
Description |
|---|---|---|
value |
any |
A value whose type is to be determined. No conversion shall take place on the argument passed to this function. |
Return Type and Value: number – The kind of the error value designated by value, as follows:
value |
Return Value |
|---|---|
#NULL! |
1 |
#DIV/0! |
2 |
#VALUE! |
3 |
#REF! |
4 |
#NAME? |
5 |
#NUM! |
6 |
#N/A |
7 |
Anything else |
#N/A |
example: