ISNONTEXT function

Category: Information
Introduced: Excel 2003

Summary

Returns TRUE if the value is not text

Syntax

ISBLANK(value) ISERR(value)
ISERROR(value)
ISEVEN(value)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISODD(value)
ISREF(value)
ISTEXT(value)
The IS function syntax has the following argument:
• value Required. The value that you want tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.
ISBLANK | Value refers to an empty cell.
ISERR | Value refers to any error value except #N/A.
ISERROR | Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISEVEN | Value refers to an even number.
ISLOGICAL | Value refers to a logical value.
ISNA | Value refers to the #N/A (value not available) error value.
ISNONTEXT | Value refers to any item that is not text. (Note that this function returns TRUE if the value refers to a blank cell.)
ISNUMBER | Value refers to a number.
ISODD | Value refers to an odd number.
ISREF | Value refers to a reference.
ISTEXT | Value refers to text.

Example

=ISLOGICAL(TRUE)
=ISLOGICAL("TRUE")
=ISNUMBER(4)
=ISREF(G8)
=ISREF(XYZ1)
=ISBLANK(A2)
=ISERROR(A4)
=ISNA(A4)
=ISNA(A6)
=ISERR(A6)
=ISNUMBER(A5)
=ISTEXT(A3)

Microsoft Support Page

#NOT_FOUND

Back to Functions