Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
The TYPE Function
The Purpose of the TYPE Function
The TYPE function will return an integer that represents the type of data that is in a cell. This function could be useful for display the types of data within records.
How the Type Function Works
The TYPE function needs to be inputted into a cell in a very specific manner for it to work properly. To type this formula into a cell, a cell needs clicked and "=TYPE(" needs to be entered first. After the open parenthesis, a cell reference is used, followed by a closed parenthesis. After the formula is created, the enter button can be pressed to return a number that indicates what type of data is in the cell that was referenced in the function.
As stated, there are only six results that the TYPE function can return. Each of these six types of data are defined in detail below:
1 - When the result is a 1 the data referenced is a number.
2 - When the result is a 2 the data referenced is text data.
4 - When the result is a 4 the data referenced is a logical value.
16 When the result is a 16 the data referenced is an error value.
64 When the result is a 64 the data referenced is an array.
Inserting the TYPE Function
The TYPE function can be inserted into a spreadsheet with the use of an insert tool. This tool may be preferred by some because of the step-by-step instructions that are given in the process.
To insert a function a cell needs to be selected. Next, the formulas tab is selected and the "More Functions" button on the Excel ribbon needs to be selected. The information selection from the list is then chosen, followed by selecting the type option.
Selecting the Type Function
After the functions arguments window appears, a cell reference can either be typed or selected from the worksheet by clicking on the up arrow to the right of the value field.
Notice the reference under the value field. This reference indicates what value will be returned depending on what type of data is referenced. Once the reference is entered into the value field a preview of of the number that will be displayed will appear in the bottom left-hand corner of this window. Additionally, any data can be entered into the values field to see what type of data it is.
After the reference is selected, click on the OK button.
Recommended for you
The Functional Arguments Window
TYPE Function Examples
In this TYPE formula in the above example will display the type of value in the cell A2. If the type of data in cell reference A2 were a name such as Joshua, then the number 1 would appear in the cell where this formula is used.
Returns the type of London, which is text, ??
Returns the type of formula in b4 which is 16 the type fo errro message #VALUE!
In this TYPE function the number 64 is returned since there is an array constant. Any cell that has compound data as such will return this this number.
Here a calculation is made where a the number 1 is returned since a number would be a result of the of the calculation.
Microsoft. (n.d.). TYPE function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/type-function-45b4e688-4bc3-48b3-a105-ffa892995899.
To learn more about using functions like the TYPE function and other skill in Excel I recommend the following book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2020 Joshua Crowder