The Excel ISNUMBER Function

Basic Description

The Excel Isnumber function tests if a supplied value is a number. If so, the function returns TRUE; Otherwise it returns FALSE.

The syntax of the function is:

ISNUMBER( value )

Where the supplied value is the value or expression to be tested.


Isnumber Function Examples

The spreadsheets below show several examples of the Excel Isnumber function:

 Formulas:
 AB
1=ISNUMBER( 1 ) 
2=ISNUMBER( "text" ) 
3=ISNUMBER( 10/2 ) 
4=ISNUMBER( B4 )#VALUE!
5=ISNUMBER( B5 )10
6=ISNUMBER( B6 ) 
 Results:
 AB
1TRUE 
2FALSE 
3TRUE 
4FALSE#VALUE!
5TRUE10
6FALSE 

Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.