OpenOffice3.org Calc 3. Information Functions
TYPE(value) Function
Returns a numeric value. Indicates the type of data contained in the given argument. The argument “value” contains the reference to a cell, a constant or an expression. Depending on the type of data, the function returns an integer that indicates the type of data, as explained below:
| Returns | The type is |
| 1 | Numerical value. |
| 2 | The data is text. |
| 4 | The data is boolean. |
| 8 | The cell contains a formula. |
| 16 | Contains an error value. |
For example:
=TYPE(33) Returns 1. The argument is a numeric value.
=TYPE("rojo") Returns 2. The argument is text.
=TYPE(33/0) Returns 16. The result set of the expression in the argument is an error, is dividing a number by 0.