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:

ERROR.TYPE(A1) results in 2 if A1 evaluates to #DIV/0!
ERROR.TYPE(A1) results in 4 if A1 evaluates to #REF/0!
ERROR.TYPE(A1) results in 7 if A1 evaluates to #N/A
ERROR.TYPE(A1) results in #N/A if A1 evaluates to a non-error value, such as a number or text

end example]