ERROR.TYPE(error_val)

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


error_valThe 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.
* For the Microsoft documentation refer to support.office.com

 AB
1=ERROR.TYPE(#NULL!) = 110
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 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top