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.