Google Sheets

ISNONTEXT function in Google Sheets

Checks whether a value is non-textual.

=ISNONTEXT(value)

ISNONTEXT syntax and parameters

One argument, one required.

valueanyRequired
The text to be checked. ISNONTEXT returns FALSE if this is a text value or a reference to a cell containing a text value and TRUE otherwise. When value is a reference to an empty cell, ISNONTEXT will return TRUE. When value is an empty string, ISNONTEXT will return FALSE, as the empty string is considered text.

Formulas you'll actually reuse.

Is the amount a number, a blank, or a boolean rather than text?
```
=ISNONTEXT(C2)
```
ResultTRUE
Rows whose email cell is blank or not text at all:
```
=SUMPRODUCT(--ISNONTEXT(B2:B200))
```
Result6

Same name — your formula ports as-is.

Edit the example — nothing to install.

Preloaded with the ISNONTEXT formula from Example 1 — change anything and watch it respond.

Loading the editor…

More ways Google Sheets gets this done.