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 can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.


Isnontext Function Examples

The spreadsheets below show examples of the Excel Isnontext function. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the results:

 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