What does it do?

Gets the data type from a value

Formula breakdown:

=TYPE(value)

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

DOWNLOAD EXCEL WORKBOOK

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

=TYPE(

TYPE Formula in Excel

 

STEP 2: The TYPE arguments:

Table of Contents

value

What is the value to get the data type from?

Select the cell containing the value:

=TYPE(C9)

TYPE Formula in Excel

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

See also  DAY Formula in Excel

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

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin