The Excel ISNONTEXT function tests whether a value is anything except text (numbers, blanks, errors, logicals all count). It returns TRUE or FALSE, making it the building block of error-proof formulas, validation, and conditional logic.
Syntax
| Argument | Description | |
|---|---|---|
value | Required | The value, cell, or expression to test. |
How to use it
ISNONTEXT returns TRUE when the value is NOT text, and FALSE otherwise. Wrap it in IF to act on the result, or sum it with SUMPRODUCT to count matches: =SUMPRODUCT(--ISNONTEXT(A2:A100)).
The IS family: ISBLANK, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR, ISERROR, ISNA, ISREF, ISFORMULA, ISEVEN, and ISODD each return TRUE or FALSE so you can branch with IF, count with SUMPRODUCT, or drive conditional formatting.
Try it: interactive demo
Pick an input and watch the formula and result update.
Practice workbook
Frequently asked questions
How do I act on the TRUE/FALSE result?
Can I count how many cells pass?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class