Documentation/Calc Functions/ISNONTEXT

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎Nederlands • ‎italiano



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:

ISLOGICAL

ISNUMBER

ISTEXT

ODF standard:

Section 6.13.21, part 2

Equivalent Excel functions:

ISNONTEXT