Difference between revisions of "Documentation/How Tos/Calc: T function"

Latest revision as of 15:41, 2 February 2024

FUNCTIONS

Returns the given text, or an empty text string if the target is not text.

T(value)

if value is text, it is returned.

if value is a number or a logical value, an empty text string "" is returned.

T("red car")

returns red car.

T(123.4)

returns an empty text string.

ISTEXT(T(123.4))

returns TRUE.

T(NA())

returns the #N/A error. Errors are propagated.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:T function}}
+{{Documentation/CalcFunc TextTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_SUBSTITUTE_function
+|NextPage=Documentation/How_Tos/Calc:_TEXT_function
+}}__NOTOC__
 == T ==
@@ Line 23: / Line 28: @@
 : returns the <tt>'''#N/A'''</tt> error. Errors are propagated.
-{{Documentation/SeeAlso|
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: TEXT function|TEXT]]
 * [[Documentation/How_Tos/Calc: N function|N]]