Excel Functions

Excel ISNONTEXT Function

Pinterest LinkedIn Tumblr

ISNONTEXT function can be used to check for a value that is not text.

Purpose of Excel ISNONTEXT Function

The function helps to check if a cell contains text or not (is anything typed into a cell?). 

Return value

This function returns TRUE if the value is not text.
This function returns FALSE if the value is text.


=ISNONTEXT (value)


valueThe value to checkMandatory

Usage notes

  • ISNONTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.


since 2007 for windows,2011 for Mac

Related Posts

Write A Comment