Related Topics: | ||
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]
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.