Documentation/Calc Functions/ISTEXT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

ISTEXT

Category:

Information

Summary:

Returns TRUE if the cell contents refer to text.

Syntax:

ISTEXT(Value)

Returns:

If an error occurs, the function returns FALSE.

Arguments:

Value is a value, number, Boolean value, or an error value to be tested.

Additional details:

Examples:

=ISTEXT(D9) returns TRUE if cell D9 contains the text abcdef.

=ISTEXT(C3) returns FALSE if cell C3 contains the number 3.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: