Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > ISNUMBER
 

ISNUMBER(value)

 
 Returns the boolean value depending if the value is number.

 valueThe value you want to test.

 REMARKS
 
  		• The "value" can refer to a value, cell reference, formula or a named range.

     EXAMPLES
     
     AB
    1=ISNUMBER(4) = True20
    2=ISNUMBER(1.25) = Truesome text
    3=ISNUMBER(-100) = True""
    4=ISNUMBER(B1) = True 
    5=ISNUMBER("some text") = False 
    6=ISNUMBER(B2) = False 
    7=ISNUMBER(B3) = False 
    8=ISNUMBER(B4) = False 
    9=ISNUMBER(TRUE) = False 
    10=ISNUMBER(FALSE) = False 
    		 
     Functions - I | Index - I | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top