Documentation/Calc Functions/ISNONTEXT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

ISNONTEXT

Category:

Information

Summary:

Tests if the cell contents are text or numbers, and returns FALSE if the contents are text.

Syntax:

ISNONTEXT(Value)

Returns:

If an error occurs, the function returns TRUE.

Arguments:

Value is any value or expression where a test is performed to determine whether it is a text or numbers or a Boolean value.

Additional details:

Examples:

=ISNONTEXT(D2) returns FALSE if cell D2 contains the text abcdef.

=ISNONTEXT(D9) returns TRUE if cell D9 contains the number 8.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: