Purpose

Return value

Syntax

=ISNONTEXT(value)
  • value - The value to check.

Using the ISNONTEXT function

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.

Examples

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

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

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

=ISNONTEXT(A1) // returns TRUE

If cell A1 is empty, ISNONTEXT returns TRUE:

=ISNONTEXT(A1) // returns TRUE

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

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

Note: the ampersand (&) is the concatenation operator in Excel. When values are concatenated, the result is text.

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:

=SUMPRODUCT(--ISNONTEXT(range))

The double negative coerces the TRUE and FALSE results from ISNONTEXT into 1s and 0s and SUMPRODUCT sums the result. You can also use the COUNTIF function to count cells that do not contain text, as explained here .

Notes

  • When value is a number, ISNONTEXT returns TRUE.
  • When value is any error, ISNONTEXT returns TRUE.
  • When value is an empty cell, ISNONTEXT returns TRUE.

Purpose

Return value

Syntax

=ISNUMBER(value)
  • value - The value to check.

Using the ISNUMBER function

The ISNUMBER function returns TRUE when a cell contains a number, and FALSE if not. You can use ISNUMBER to check that a cell contains a numeric value, or that the result of another function is a number.

The ISNUMBER 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 a number, the ISNUMBER function will return TRUE. Otherwise, ISNUMBER will return FALSE.

Examples

The ISNUMBER function returns TRUE if value is numeric:

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

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

=ISNUMBER(A1) // returns TRUE

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

=ISNUMBER(2+2) // returns TRUE
=ISNUMBER(2^3) // returns TRUE
=ISNUMBER(10 &" apples") // returns FALSE

Note: the ampersand (&) is the concatenation operator in Excel. When values are concatenated, the result is text.

Count numeric values

To count cells in a range that contain numbers, you can use the SUMPRODUCT function like this:

=SUMPRODUCT(--ISNUMBER(range))

The double negative coerces the TRUE and FALSE results from ISNUMBER into 1s and 0s and SUMPRODUCT sums the result.

Notes

  • ISNUMBER will return TRUE for Excel dates and times since they are numeric.
  • ISNUMBER will return FALSE for empty cells and errors.