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

ISNONTEXT(value)

 
 Returns the boolean value depending if the value is text.

 valueThe value you want to test.

 REMARKS
 
  		• The "value" can refer to a value, cell reference, formula or a named range.
     
  		• If "value" is a cell reference to an empty cell, then True is returned.

     EXAMPLES
     
     A
    1=ISNONTEXT("some text") = False
    2=ISNONTEXT(10) = True
    3=ISNONTEXT(B3) = True
    4=ISNONTEXT(10/0) = True
    5=ISNONTEXT(named_range) = False
    		 
     Functions - I | Index - I | Office Online 

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