ISNONTEXT

Description

ISNONTEXT determines if the specified expression is not text.

Syntax

ISNONTEXT ( expression )

 

Parameter

Description

expression

Any expression.

Remarks

If the expression returns any value that is not text, True is returned. Otherwise, False is returned.

Examples

This function returns True if cell F3 contains a number or is a blank cell:

ISNONTEXT(F3)

This function returns False:

ISNONTEXT("text")

Also, see

ISBLANK

ISERR

ISERROR

ISLOGICAL

ISNA

ISNUMBER

ISREF

ISTEXT