ERROR.TYPE

ERROR.TYPE(error_val)

Returns the number corresponding to a particular error value in a cell.

error_val

The error or formula that returns the error you want to identify.

REMARKS

* Although "error_val" can be the actual error value, it will typically be a reference to a cell containing a formula.
* If "error_val" evaluates to anything other than an error, then #N/A is returned.
* If "error_val" evaluates to #NULL!, then 1 is returned.
* If "error_val" evaluates to #DIV/0!, then 2 is returned.
* If "error_val" evaluates to #VALUE!, then 3 is returned.
* If "error_val" evaluates to #REF!, then 4 is returned.
* If "error_val" evaluates to #NAME?, then 5 is returned.
* If "error_val" evaluates to #NUM!, then 6 is returned.
* If "error_val" evaluates to #N/A, then 7 is returned.
* If "error_val" evaluates to #GETTING_DATA, then 8 is returned. Added in 2007.
* This function will always be single threaded.
* You can use the IFERROR function to return a value or something else if it evaluates to an error.
* You can use the ISERROR function to return the boolean True or False depending if the value is an error.
* You can use the ISBLANK function to return the boolean True or False depending if the value is blank.
* You can use the ISNA function to return the boolean True or False depending if the value is #N/A.
* You can use the ISREF function to return the boolean True or False depending if the value is a cell reference.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=ERROR.TYPE(#NULL!) = 1	10
2	=ERROR.TYPE(#DIV/0!) = 2
3	=ERROR.TYPE(#VALUE!) = 3
4	=ERROR.TYPE(#REF!) = 4
5	=ERROR.TYPE(#NAME?) = 5
6	=ERROR.TYPE(#NUM!) = 6
7	=ERROR.TYPE(#N/A) = 7
8	=ERROR.TYPE(#GETTING_DATA) = 8
9	=ERROR.TYPE(B1) = #N/A
10	=ERROR.TYPE(10) = #N/A
11	=ERROR.TYPE(3) = #N/A