ISNONTEXT

Name

Is nontext

Description

Tests for non-text data.

Syntax

ISNONTEXT(value)

Remarks

Returns 1 (True) if the value argument is or refers to any item that is not text. (If the cell is empty, the function returns 1 (True).) Returns 0 (False) if the value argument is or refers to any item that is text.

See also ISNUMBER and ISTEXT.

Data Type

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

Example

ISNONTEXT(R1C2)
ISNONTEXT(A3)
ISNONTEXT(12) = 1 (True)