TYPE(value) returns a number indicating the data type of a value : TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. TYPE
1 is returned for numbers.

2 is returned for text.

4 is returned for logical values.

16 is returned for errors.

64 is returned for arrays.








17.16.TYPE
17.16.1.TYPE(value) returns a number indicating the data type of a value
17.16.2.=TYPE(A1) checks the type of the value above=TYPE(A1) checks the type of the value above
17.16.3.=TYPE(2+"A") checks the type of the formula, which returns the error #VALUE!=TYPE(2+
17.16.4.=TYPE({1,2;3,4}) checks the type of an array constant=TYPE({1,2;3,4}) checks the type of an array constant