ISNONTEXT

Checks whether the specified value refers to any item that is not text, including blank cells.

Syntax

ISNONTEXT( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is a text value, returns FALSE. If x is a reference to a cell, the value of the referenced cell is tested. Blank cells are not considered texts. If x is an error value, this error value is returned. In any other case, the function returns TRUE.

Example

Formula

=ISNONTEXT(A1)
=ISNONTEXT("Value")

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISNA Function
ISTEXT Function
TYPE Function