T

Description: Returns the text referred to by value.

Syntax: T(Value)

• Value is the value you want to test.

Remarks:

• If Value is or refers to text, T returns value. If Value does not refer to text, T returns "" (empty text).
• You do not generally need to use the T function in a formula because the software automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.

Example:

If cells A2:A4 contain Rainfall, 19 and TRUE:

• T(A2) = Rainfall [because the cell value is text, the text is returned]
• T(A3) = () [because the cell value is a number, empty text is returned]
• T(A4) = () [because the third value is a logical value, empty text is returned]