TYPE

TYPE

Synopsis

TYPE(value)

Description

TYPE returns a number indicating the data type of a value.

1 == number

2 == text

4 == boolean

16 == error

64 == array

  • This function is Excel compatible.

Examples

TYPE(3) equals 1.

TYPE("text") equals 2.

See also