Search notes:

Excel function: TYPE

type(val) returns a number that indicates the data type (of a cell?):
1 number
2 text
4 logical value
16 error value
64 array
If the value that is passed to type() reference that points to an empty cell, then val(ref) returns 1, indicating a number.

Circular references

The following formula has a circular reference. It evaluates to 0: 
=type( indirect( address( row(), column() )))

See also

Getting a cell's type in VBA: 
debug.print typename(selection.value)
These values (1, 2, 4, 8, 64) are also used in the range.specialCells method.
is functions
Excel functions

Index