Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isnumber-Function

The Excel ISNUMBER Function

Related Functions:
ISERROR
ISLOGICAL
ISNUMBER
ISREF
ISTEXT

Function 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 spreadsheet below shows several examples of the Excel Isnumber function:

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

For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.


Return to the Excel Information Functions Page
Return to the List of All Built-In Excel Functions