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.

## Leave a Comment