How to Use the TYPE Function in Excel - TurboFuture - Technology
Updated date:

How to Use the TYPE Function in Excel

Joshua has work experience in manufacturing, distribution, and aerospace. He received his BBA in accounting from Kent State University.

The TYPE Function

This illustration shows the TYPE function being used with a cell reference. The TYPE function is great for understanding what type of data is available. This function is very useful when using functions that can accept varying types of data.

This illustration shows the TYPE function being used with a cell reference. The TYPE function is great for understanding what type of data is available. This function is very useful when using functions that can accept varying types of data.

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.

Example: 365

2 - When the result is a 2 the data referenced is text data.

Example: Text

4 - When the result is a 4 the data referenced is a logical value.

Example: False

16 When the result is a 16 the data referenced is an error value.

Example: #DIV/0!

64 When the result is a 64 the data referenced is an array.

Example: =TYPE(J5:J9)

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

To insert the TYPE function from the formula tab you must first navigate to: Formulas→More Functions→Information→TYPE

To insert the TYPE function from the formula tab you must first navigate to: Formulas→More Functions→Information→TYPE

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.

The Functional Arguments Window

The functional arguments window show you fields for the function that you want to insert while also giving you the ability to select cells or a range from an arrow while giving instruction on what type of data should appear in that field.

The functional arguments window show you fields for the function that you want to insert while also giving you the ability to select cells or a range from an arrow while giving instruction on what type of data should appear in that field.

TYPE Function Examples

=TYPE(A2)

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.

=TYPE("London"&A3)

Returns the type of London, which is text, ??

=TYPE(A4+5)

Returns the type of formula in b4 which is 16 the type fo errro message #VALUE!

=TYPE({1,2,3,4})

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.

=TYPE(10/2)

Here a calculation is made where a the number 1 is returned since a number would be a result of the of the calculation.

References

Microsoft. (n.d.). TYPE function. Retrieved January 5, 2020, from https://support.office.com/en-us/article/type-function-45b4e688-4bc3-48b3-a105-ffa892995899.

Related Articles

How to Use the COUNT Function in Excel

How to Use the AVERAGE Function in Excel

How to Use the ABS Function in Excel

How to Remove Errors in Excel With the IFERROR Function

How to Use the VLOOKUP Function in Excel

Converting Measurement Units: Using the CONVERT Function

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