T
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 values are generally converted as necessary.
Example
| Formula | Description (Result) |
|---|---|
| =T("Rainfall") | Because the value is text, the text is returned (Rainfall) |
| =T(19) | Because the value is a number, empty text is returned () |
| =T(TRUE) | Because the value is a logical value, empty text is returned () |