Joshua is a graduate student at the USF. He has interests in business technology, analytics, finance, and lean six sigma.
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 displaying 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 manually add this function to a cell needs to be clicked and =TYPE( needs to be entered first. After the open parenthesis, a cell reference is used, followed by a closing 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 is 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 insertion 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 function 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 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.
The Function Arguments Window For the TYPE Function
TYPE Function Examples
This TYPE formula in the above example will display the type of value in 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 of error 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 number.
Here a calculation is made where the number 1 is returned since a number would be a result 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.
- How to Use the TREND Function in Excel
Covers how to use the TREND function in Microsoft Excel with the correct syntax and an example.
- How to Use the RAND Function in Excel
Covers how to use the RAND function in Microsoft Excel with examples on the correct syntax to use.
- Converting Measurement Units: Using the Convert Function in Microsoft Excel
Describes how to use the CONVERT function within Microsoft Excel to convert various types of measurement units to other types of units. Types of conversions include: weight and mass, distance, time, pressure, force, energy , power, magnetism, tempera
- How to Use the VLOOKUP Function in Excel
Covers how to use the VLOOKUP function in Microsoft Excel with examples on the correct syntax to use.
- How to Remove Errors in Excel With the IFERROR Function
Shows a Microsoft Excel user how to apply the IFERROR Function to remove errors in cells.
- How to Use the ABS Function in Excel
Covers how to use the ABS function in Microsoft Excel with examples on the correct syntax to use.
- How to Use the AVERAGE Function in Excel
Shows how to use the AVERAGE function in Excel with application examples.
- How to Use the COUNT Function in Excel
Shows a Microsoft Excel user how to use the count function in a spreadsheet.
Learn More About Function Use in Excel
To learn more about using other types of functions in Excel I recommend purchasing Excel Formulas & Functions For Dummies.
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