=TYPE(A1) checks the type of the value above : TYPE « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. TYPE
Input the formula: =TYPE(A1). Press Enter to get the result.
Input the formula: =TYPE(A1)
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