ISNONTEXT

See also A-Z Spreadsheet Function List

Description Determines if the specified expression is not text.

Syntax ISNONTEXT(expression)

expression is any expression.

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

See Also ISBLANK , ISERR , ISERROR , ISLOGICAL , ISNA , ISNUMBER , ISREF , and ISTEXT functions

Examples ISNONTEXT(F3) returns True if cell F3 contains a number or is a blank cell.

         ISNONTEXT(“text”) returns False.