- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Information - TYPE Function
Description
The TYPE function receives a value and returns an integer that represents the specified value's data type. Use TYPE when the behavior of another Function depends on the type of value in a particular cell.
Syntax
TYPE (value)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Value | Value or a reference to a cell containing the value that you want to know the type of. Data type can be a number, text, logical value, etc. Look at the Table below for the Integers that TYPE Function returns and the corresponding Data types. |
Required |
| Integer returned by TYPE Function | Corresponding Data Type |
|---|---|
| 1 | Number |
| 2 | Text |
| 4 | Logical value |
| 16 | Error value |
| 64 | Array |
Notes
TYPE evaluates an empty cell as the value 0, and hence returns the integer 1, to denote a Number.
TYPE is most useful when you are using Functions that can accept different types of data. Use TYPE to find out what type of data is returned by a Function or Formula.
You cannot use TYPE to determine whether a cell contains a Formula. TYPE only determines the type of the resulting, or displayed, value. If value is a cell reference to a cell that contains a Formula, TYPE returns the type of the Formula's resulting value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
