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

Latest revision as of 13:27, 31 January 2024

FUNCTIONS

Tests if a cell contains text.

ISTEXT(value)

Returns TRUE if value is or refers to text, and FALSE otherwise.

ISTEXT(“dog”)

returns TRUE.

ISTEXT(C2)

where cell C2 contains cat returns TRUE.

ISTEXT(C3)

where cell C3 contains =NA() returns FALSE, because NA() returns an error value, not text.

ISTEXT(C4)

where C4 is an empty cell returns FALSE (an empty cell contain no text).

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:ISTEXT function}}
+{{Documentation/CalcFunc InformationTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_ISREF_function
+|NextPage=Documentation/How_Tos/Calc:_N_function
+}}__NOTOC__
 == ISTEXT  ==
 Tests if a cell contains text.
 === Syntax: ===
-<tt>'''ISEVEN(value)'''</tt>
+<tt>'''ISTEXT(value)'''</tt>
 : Returns <tt>'''TRUE'''</tt> if <tt>'''value'''</tt> is or refers to text, and <tt>'''FALSE'''</tt> otherwise.
 === Example: ===
@@ Line 24: / Line 27: @@
 : where C4 is an empty cell returns <tt>'''FALSE'''</tt> (an empty cell contain no text).
+{{SeeAlso|EN|
+* [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]]
+* [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]]
-=== See also: ===
+* [[Documentation/How_Tos/Calc: Information functions|Information functions]]
-'''[[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT function]]''',
-'''[[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER function]]'''
-'''[[Documentation/How_Tos/Calc: Information functions|Information functions]]'''
+* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
+* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+[[Category: Documentation/Reference/Calc/Information functions]]