Skip to content
Excel

ISNONTEXT function in Excel

Returns TRUE if the value is not text

=ISNONTEXT(value)

ISNONTEXT syntax and parameters

One argument, one required.

  • valueanyRequired

    The value that you want tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.

ISNONTEXT examples

Formulas you'll actually reuse.

  1. Is the amount a number, a blank, or a boolean rather than text?

    =ISNONTEXT(C2)

    ResultTRUE

  2. Rows whose email cell is blank or not text at all:

    =SUMPRODUCT(--ISNONTEXT(B2:B200))

    Result6

ISNONTEXT in Google Sheets

Same name — your formula ports as-is.

Try ISNONTEXT in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.