TYPE function

TYPE returns the type of value. If an error occurs, the function returns a logical or numeric value.

Syntax

TYPE(value)

value is a specific value for which the data type is determined. Value 1 = number, value 2 = text, value 4 = Boolean value, value 8 = formula, value 16 = error value.

Example

=TYPE(C2) returns 2.

=TYPE(D9) returns 1.