Spread 8.0 Documentation
ISTEXT
Support Options
Formula Reference > Built-In Functions > ISTEXT

Glossary Item Box

ISTEXT


Name

Is text

Description

Tests for text data.

Syntax

ISTEXT(value)

Remarks

Returns 1 (True) if the value argument is or refers to text. Returns 0 (False) if the value argument is or refers to a value that is not text.

See also ISNONTEXT and ISNUMBER.

Data Type

Accepts any data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

ISTEXT(R1C2)
ISTEXT(B3)
ISTEXT(12) = 0 (False)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.