ISNUMBER Function in Excel – Test if the Cell contains number

The ISNUMBER function in Excel, tests if an supplied expression or Value returns the number, and if so, returns TRUE, If not the function returns FALSE

Syntax of ISNUMBER Function in Excel:

ISNUMBER(value)

Where value argument is the Expression or value to be tested.

 

Example of ISNUMBER Function in Excel:

Formula:

ISNUMBER Function in Excel 1

The above example takes up simple values, Expressions and cell reference as input and returns TRUE only if the resultant value is a number, otherwise the function returns FALSE

Result:

ISNUMBER Function in Excel 2

previous-small ISNUMBER Function in Excel                                                                                                                next_small ISNUMBER Function in Excel