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.
Examples
| 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 () |