# Documentation/Calc Functions/ISNONTEXT

Other languages:
English • ‎Nederlands • ‎italiano

ISNONTEXT

Information

## Summary:

Determines if a specified cell or expression evaluates to text, returning TRUE if the argument is not text.

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.

• 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

ISNONTEXT