The Excel ISNONTEXT Function

Basic Description

The Excel Isnontext function tests if a supplied value is text. If not, the function returns TRUE; If the supplied value is text, the function returns FALSE.

The syntax of the function is:

ISNONTEXT( value )

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


Isnontext Function Examples

The spreadsheets below show examples of the Excel Isnontext function.

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

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