The value whose type should be returned.
1 if the value is a number, 2 if the value is a text string, 4 if the value is a logical value, 16 if the value is an error, 64 if the value is an array and 65536 (2^16) if the value is a color.
Returns the type of the given value. TYPE(42)TYPE(42) returns 1, indicating that 42 is a number.
These are the values returned by this function:
|Type of value||Return value|
|Logical (TRUE or FALSE)||4|
Calcapp has many additional types (representing things like number fields and reset buttons) that are not covered by this function.
Returns 1, indicating that 42 is a number.
Returns 2, indicating that "42" is a text string.
Returns 4, indicating that TRUE is a logical value.
Returns 16, provided that the value of Field2 is 0 or blank,
which triggers a
#DIV/0! error ("division by zero").
Otherwise, 1 is returned, indicating that the value is a number.
Returns 64, indicating that the value is an array.
Returns 65536, indicating that the value is a color.