T Function

The T function is one of the text and data functions. Is used to check whether the value in the cell (or used as argument) is text or not. In case it is not text, the function returns blank result. In case the value/argument is text, the function returns the same text value.

Syntax

T(value)

The T function has the following argument:

ArgumentDescription
valueThe value you want to test.
Notes

How to apply the T function.

Examples

There is an argument: value = A1, where A1 is date and time. So the function returns date and time.

T Function: Text

If we change the A1 data from text to numerical value, the function returns blank result.

T Function: Numerical Value

Host ONLYOFFICE Docs on your own server or use it in the cloud

Article with the tag:
Browse all tags