Returns a number indicating the type of the specified value.
Syntax
![]() |
---|
TYPE( Any value ) → Number |
The function returns a value indicating the type of the specified argument, according to the following table.
Type | Value |
---|---|
Number | 1 |
Text | 2 |
Logical | 4 |
Error | 16 |
Array | 64 |
If a reference is provided, the reference is first dereferenced, and any formulas are evaluated. Note that this function does not propagate error values.
Function Reference
ERROR.TYPE Function
MindFusion.Spreadsheet for WPF Programmer's Guide | © 2025 MindFusion |