- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
-
Functions T to Z
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
- VALUE
- VALUETOTEXT
- VAR
- VAR.P
- VAR.S
- VARA
- VARISPARKLINE
- VARP
- VARPA
- VBARSPARKLINE
- VDB
- VLOOKUP
- VSTACK
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WINLOSSSPARKLINE
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- YEAR
- YEARFRAC
- YEARSPARKLINE
- YIELD
- YIELDDISC
- YIELDMAT
- Z.TEST
- ZTEST
TYPE
This function returns the type of value.
Syntax
TYPE(value)
Arguments
The argument is any value as summarized here:
| Type of Value | Returned Number |
|---|---|
| Number | 1 |
| DateTime object | 1 |
| TimeSpan object | 1 |
| Text | 2 |
| Logical value | 4 |
| Error value | 16 |
| Array | 64 |
Data Types
Accepts many types of data. Returns numeric data.
Examples
TYPE(G15)
TYPE(R15C7)
TYPE(154) gives the result 1
TYPE("String") gives the result 2
TYPE(TRUE) gives the result 4
Version Available
This function is available in product version 1.0 or later.
See Also
ERRORTYPE | ISERROR | ISLOGICAL | ISNUMBER | ISTEXT | Information Functions