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

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×