The Excel ISNONTEXT Function

Related Functions:

ISERROR
ISLOGICAL
ISNUMBER
ISREF
ISTEXT
ISFORMULA

Function 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 Isnontext function is:

ISNONTEXT( value )

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

Isnontext Function Examples

The following spreadsheet shows examples of the Excel Isnontext function:

Formulas:

	A	B
1	=ISNONTEXT( TRUE )
2	=ISNONTEXT( "Peter" )
3	=ISNONTEXT( 10/2 )
4	=ISNONTEXT( B4 )	#VALUE!
5	=ISNONTEXT( B5 )	Peter
6	=ISNONTEXT( B6 )

Results:

	A	B
1	TRUE
2	FALSE
3	TRUE
4	TRUE	#VALUE!
5	FALSE	Peter
6	TRUE

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