- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
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