The T function checks to see if the contents of a cell is text. If it is, the text is returned, if not, blank is returned.

T takes 1 required argument and no optional arguments:

Syntax: T(value)

#1)
Using the T function:
#2)
The arguments for the T function are:
Argument Required? Description
value Required The value you want to test. If value is or refers to text, T returns value. If value does not refer to text, T returns "" (empty text).

Summary

The T function checks to see if the contents of a cell is text and is provided primarily for compatibility with other spreadsheet programs.
comments powered by Disqus