ISNONTEXT

Description

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 S3 contains a number or is a blank cell:

ISNONTEXT(S3)

This function returns False:

ISNONTEXT("text")

See also

ISBLANK

ISERROR

ISLOGICAL

ISNA

ISNUMBER

ISTEXT