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