Documentation/Calc Functions/ISNONTEXT

    From The Document Foundation Wiki
    Other languages:


    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

    Related (or similar) Excel functions:

    ISNONTEXT