Excel ISNONTEXT function

★ 20 minutes read

Just as it is with using other different functions in Excel, there are also ways to use the ISNONTEXT function. In this post, we’ll consider the syntax approach to using the Excel ISNONTEXT function to test for non-text values.

Excel ISNONTEXT function

Formula

=ISNONTEXT (value)

Explanation

The ISNONTEXT function in Excel is used to test for non-text values. The parameter value is the cell data to test. It returns TRUE if a value is not text, such as time, number etc, and also returns TRUE for empty cells and for cells with formulas that give non-text results.

Example 1

 

 

Figure 1. Excel ISNONTEXT function

 

In figure 1 above, the formula in cell D6 is:

=ISNONTEXT (C6)

The ISNONTEXT function returns TRUE, because the value in D6 cell (23.4) is a numeric value.

Notes

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

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar