ISNONTEXT
TheISNONTEXT
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.
 How to use
ISNONTEXT
formula?  Examples of using
ISNONTEXT
formula ISNONTEXT
formula not working? Similar formulas to
ISNONTEXT
Usage
Use the ISNONTEXT
formula with the syntax shown below, it has 1 required parameter:
 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 theISNONTEXT
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 nontext 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 nontext 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 nonnumeric 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.