Skip to main content

ISNUMBER function

The ISNUMBER function is one of the information functions. It is used to check for a numeric value. If the cell contains a numeric value, the function returns TRUE, otherwise the function returns FALSE.

Syntax​

ISNUMBER(value)

The ISNUMBER function has the following argument:

ArgumentDescription
valueThe value that you want to test. The value can be an empty cell, error, logical value, text, number, reference value, or a name referring to any of these.

Notes​

How to apply the ISNUMBER function.

Examples​

The figure below displays the result returned by the ISNUMBER function.

ISNUMBER Function