Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > TYPE
 

TYPE(value)

 
 Returns the number indicating the datatype of the value.

 valueThe value you want the datatype of.

 REMARKS
 
  		• This function can be useful when the behaviour of another function depends on the type of value in a particular cell.
     
  		• This function is most useful when you are using functions that can accept different types of data.

     EXAMPLES
     
     ABC
    1=TYPE(C1) = 11 = Number25
    2=TYPE(2+C1) = 1 surname
    3=TYPE("text") = 22 = Text 
    4=TYPE("MR. "&C2) = 2  
    5=TYPE(TRUE) = 44 = Logical 
    6=TYPE(FALSE) = 4  
    7=TYPE(10/0) = 1616 = Error Value 
    8=TYPE({1,2;3,4}) = 6464 = Array 
    		 
     Functions - T | Index - T | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top