Documentation/Calc Functions/ISTEXT
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ISTEXT
Category:
Information
Summary:
Determines if a specified cell or expression evaluates to text, returning TRUE if the argument is text.
Syntax:
ISTEXT(Value)
Returns:
Returns TRUE if the argument evaluates to text and returns FALSE otherwise.
Arguments:
Value is an expression, or a reference to a cell containing an expression, that is to be tested for text content.
Additional details:
- If the argument is a reference to an empty cell, ISTEXT returns FALSE.
- ISTEXT does not propagate errors. If Value evaluates to a string, then ISTEXT returns TRUE and returns FALSE otherwise.
- The formula
=ISTEXT(X)
is equivalent to=NOT(ISNONTEXT(X))
.
Examples:
Formula | Description | Returns |
---|---|---|
=ISTEXT("example pattern") | Here the function returns TRUE because the argument is a text string. | TRUE |
=ISTEXT(74.56) | Here the function returns FALSE because the argument is a decimal number, not a string. The same result would arise for the formulas =ISTEXT(2022-01-22) and =ISTEXT(TRUE()) . |
FALSE |
=ISTEXT(D1) where cell D1 contains the string "LibreOffice Calc". | Here the function returns TRUE because the argument is a reference to a cell containing a text string. | TRUE |
=ISTEXT(D2) where cell D2 is empty. | Here the function returns FALSE because the argument is a reference to an empty cell. | FALSE |
=ISTEXT(1/0) | Here the function returns FALSE because the argument is not a string. Note that ISTEXT does not propagate the #DIV/0! that arises from the division by 0. | FALSE |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ISTEXT