T

T(value)

Returns the argument as a text string when the value is text.

value

The value you want to test.

REMARKS

* This function is only available for backwards compatibility and should not be used.
* If "value" is text, then "value" is returned.
* If "value" is a number, "" (empty string) is returned.
* This function is not used a lot as Microsoft Excel automatically converts values when necessary.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=T("sometext") = sometext	sometext
2	=T("true") = true	True
3	=T("20+100") = 20+100	20
4	=T(100) = ""
5	=T(B1) = sometext
6	=T(B2)=""
7	=T(B3)=""

1 - What is the text in the string "sometext".
2 - What is the text in the string "true".
3 - What is the text in the string "20+100".
4 - This is a numerical value so an empty string is returned.
5 - What is the text in the cell "B1".
6 - What is the text in the cell "B2". This is a boolean value so an empty string is returned.
7 - What is the text in the cell "B3". This is a numerical value so an empty string is returned.