What does it do?

Gets the data type from a value

Formula breakdown:


What it means:

=TYPE(value to be checked for its data type)

Do you need to check the data type of your values? The TYPE Formula in Excel is perfect for this!

The TYPE- Formula checks for the following data types:

  • 1 – number
  • 2 – text
  • 4 – logical value
  • 16 – error value
  • 64 – array

I explain how you can do this below:

TYPE Formula in Excel | MyExcelOnline


STEP 1: We need to enter the TYPE function in a blank cell:


TYPE Formula in Excel


STEP 2: The TYPE arguments:


What is the value to get the data type from?

Select the cell containing the value:


TYPE Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

TYPE Formula in Excel

You now have your data types!

TYPE Formula in Excel


How to Use the TYPE Formula in Excel




TYPE Formula in Excel | MyExcelOnline


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook


Tweet about this on Twitter

Share on LinkedIn