- Document Solutions for Excel .NET Overview
- Key Features
- Getting Started
- Features
- Templates
- Formula Reference
- File Operations
- Tutorials
- Document Solutions Data Viewer
- API Reference
- Release Notes
TYPE
This function returns the type of value.
Syntax
TYPE(value)
Arguments
[Required] 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 |
Examples
TYPE(G15)
TYPE(R15C7)
TYPE(154) gives the result 1
TYPE("String") gives the result 2
TYPE(TRUE) gives the result 4