Sunday, November 18, 2018

T function

T function

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

No comments:

Post a Comment