ISNUMBER

Excel Functions

Test for numeric value

Syntax

EXCEL

=ISNUMBER(value)

Arguments

Parameter	Description
`value`	The value to check.

Return Value

A logical value (TRUE or FALSE)

Details

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. The ISNUMBER function returns TRUE if value is numeric: If cell A1 contains the number 100, ISNUMBER returns TRUE: If a cell contains a formula, ISNUMBER checks the result of the formula:

Examples

The ISNUMBER function returns TRUE if value is numeric:

EXCEL

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

Examples

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

EXCEL

=ISNUMBER(A1) // returns TRUE

Examples

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

EXCEL

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

Count numeric values

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

EXCEL

=SUMPRODUCT(--ISNUMBER(range))

ISNUMBER

Syntax

Arguments

Return Value

Details

Examples

See Also