Pinterest Pixel

TYPE Formula in Excel

  What does it do? Gets the data type from a value Formula breakdown: =TYPE(value) What it... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

TYPE Formula in Excel | MyExcelOnline TYPE Formula in Excel | MyExcelOnline

 

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 workbookTYPE-FORMULA.xlsx

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.

TYPE Formula in Excel

You now have your data types!

See also  New Excel Formulas in OFFICE 365: FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY and UNIQUE!

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 it
TYPE Formula in Excel | MyExcelOnline TYPE Formula in Excel | MyExcelOnline
TYPE Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...