Excel ISNONTEXT Function

Using the Excel ISNONTEXT Function

Excel ISNONTEXT Function

Summary

The Excel ISNONTEXT function will return TRUE when a cell contains a non-text value, such as a number, date, or time. The function also returns TRUE for blank cells and for cells containing formulas that return a non-text result.

Syntax

=ISNONTEXT (Value)

Syntax Breakdown

Value
Required. A value that will be tested for non-text values.

Usage Notes

ISNONTEXT checks for non-text values in a cell. If non-text values are found the function returns TRUE.

ISNONTEXT is considered one of Excel's IS functions. These functions are used to test conditions and return TRUE or FALSE.