ISNONTEXT function

ISNONTEXT tests if the cell contents are text or numbers, and returns FALSE if the contents are text. If an error occurs, the function returns a logical or numeric value.

Syntax

ISNONTEXT(value)

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

Examples

=ISNONTEXT(D2) returns FALSE.

=ISNONTEXT(D9) returns TRUE.