Check Sheet Logo
Check Sheet

ISNONTEXT

The ISNONTEXT formula is used to determine if a value is not text. It returns TRUE if the value is not text, and FALSE if the value is text. This formula is commonly used to check if a cell contains text or not.

Usage

Use the ISNONTEXT formula with the syntax shown below, it has 1 required parameter:

=ISNONTEXT(value)
Parameters:
  1. value (required):
    The value that you want to check if it is not text. It can be a reference to a cell that contains a value, or a value itself.

Examples

Here are a few example use cases that explain how to use the ISNONTEXT formula in Google Sheets.

Check if a cell does not contain text

You can use the ISNONTEXT formula to check if a cell does not contain text. For example, you can use this formula to check if a cell contains a number, a date, or a blank value.

Combine with other formulas

You can combine the ISNONTEXT formula with other formulas, such as IF or AND, to perform more complex calculations. For example, you can use the IF(ISNONTEXT(A1), B1, C1) formula to return the value in cell B1 if cell A1 does not contain text, or the value in cell C1 if cell A1 contains text.

Check if a range does not contain text

You can use the ISNONTEXT formula with a range of cells to check if any of the cells do not contain text. For example, you can use the formula =COUNTIF(A1:A10, "<>"&ISNONTEXT(A1))=0 to check if all cells in the range A1:A10 contain text.

Common Mistakes

ISNONTEXT not working? Here are some common mistakes people make when using the ISNONTEXT Google Sheets Formula:

Not providing a value

If no value is provided to the ISNONTEXT formula, it will return an error. Make sure to provide a value for the formula to check.

Using the wrong data type

The ISNONTEXT formula only works with text data types. If you use it with a non-text data type, it will return a false result. Make sure to check the data type of your values before using the formula.

Incorrectly using quotation marks

When using the ISNONTEXT formula, make sure to use the correct quotation marks around the value you want to check. Using the wrong type of quotation marks can cause errors.

Not using the formula correctly

The ISNONTEXT formula only takes one argument, the value you want to check. Make sure to use the correct syntax and provide the value in the correct place.

Confusing ISNONTEXT with ISTEXT

ISNONTEXT returns true if the value is not text, while ISTEXT returns true if the value is text. Make sure to use the correct formula for your needs.

Related Formulas

The following functions are similar to ISNONTEXT or are often used with it in a formula:

  • ISTEXT

    The ISTEXT function checks whether the value provided is a text string or not. It returns TRUE if the value is text and FALSE if it is any other data type. This function is commonly used when working with data sets that contain text and non-text values.

  • ISNUMBER

    The ISNUMBER formula is used to check if a given value is a number. It returns TRUE if the value is a number and FALSE if it is not. This formula is commonly used in data cleaning and validation to identify and remove non-numeric values or to ensure that a cell only contains a number.

  • IF

    The IF formula is a logical function used to test a condition and return one value if the condition is true and another value if the condition is false. It is commonly used to create conditional statements and perform calculations based on certain conditions.

  • AND

    The AND function in Google Sheets is a logical function that returns TRUE if all of the logical expressions in the argument are TRUE, and FALSE if any of the logical expressions are FALSE. It can be used to test multiple conditions and evaluate whether they are all true or not.

Learn More

You can learn more about the ISNONTEXT Google Sheets function on Google Support.