Documentation/Calc Functions/TYPE

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TYPE

Category:

Information

Summary:

Returns the type of value.

Syntax:

TYPE(Value)

Returns:

1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array.

If an error occurs, the function returns a logical or numerical value

Arguments:

Value is a specific value for which the data type is determined.

Additional details:

Examples:

The data in the following table serves as the basis for some of the examples in the function descriptions:

C D
2 x value y value
3 -5 -3
4 -2 0
5 -1 1
6 0 3
7 2 4
8 4 6
9 6 8

=TYPE(C2) returns 2 as a result.

=TYPE(D9) returns 1 as a result.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: