TYPE

Returns a text string indicating the type of a parameter.

Syntax:

TYPE( expression )

Returns the type of the expression parameter as a text string, which will be one of:

Important note:

TYPE(A1) will always return the text string "reference", but TYPE(DEREF(A1)) will return the type of the data in cell A1.

Example:

TYPE(25)

returns the text string "number".