ISNONTEXT Function in Google Sheets

Determine if a value is not text using the ISNONTEXT function.

ISNONTEXT Function

The ISNONTEXT function in Google Sheets is used to check if a value is not text.

Syntax

ISNONTEXT(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Non-Text Value Check

Check if a cell contains non-text content:

=ISNONTEXT(A1)

This will return TRUE if A1 contains anything other than text.

Notes

  • Returns TRUE for numbers, booleans, errors, and empty cells.
  • Use this function to exclude text from specific operations.
  • ISTEXT: Check if a value is text.
  • ISNUMBER: Check if a value is numeric.