ISNONTEXT

Excel Functions

Test for a non-text value

Syntax

EXCEL

=ISNONTEXT(value)

Arguments

Parameter	Description
`value`	The value to check.

Return Value

A logical value (TRUE or FALSE)

Details

The ISNONTEXT function returns TRUE when a cell contains any value except text. This includes numbers, dates, times, errors, and formulas that return non-text results. ISNONTEXT also returns TRUE when a cell is empty. The ISNONTEXT function takes one argument, value, which can be a cell reference, a formula, or a hardcoded value. Typically, value is entered as a cell reference like A1. When value is not text, the ISNONTEXT function will return TRUE. If value is text, ISNONTEXT will return FALSE. The ISNONTEXT function returns TRUE for numbers and FALSE for text: If cell A1 contains the number 100, ISNONTEXT returns TRUE: If cell A1 is empty, ISNONTEXT returns TRUE:

Examples

The ISNONTEXT function returns TRUE for numbers and FALSE for text:

EXCEL

=ISNONTEXT(100) // returns TRUE
=ISNONTEXT("apple") // returns FALSE

Examples

If cell A1 contains the number 100, ISNONTEXT returns TRUE:

EXCEL

=ISNONTEXT(A1) // returns TRUE

Examples

If cell A1 is empty, ISNONTEXT returns TRUE:

EXCEL

=ISNONTEXT(A1) // returns TRUE

Examples

If a cell contains a formula, ISNONTEXT checks the result of the formula:

EXCEL

=ISNONTEXT(2+2) // returns TRUE
=ISNONTEXT(10 &" apples") // returns FALSE
=ISNONTEXT(A1&B1) // returns FALSE

Count text non values

To count cells in a range that do not contain text with the ISNONTEXT function, you can use the SUMPRODUCT function like this:

EXCEL

=SUMPRODUCT(--ISNONTEXT(range))

ISNONTEXT

Syntax

Arguments

Return Value

Details

Examples

See Also