ISNONTEXTformula is used to determine if a value is not text. It returns
TRUEif the value is not text, and
FALSEif the value is text. This formula is commonly used to check if a cell contains text or not.
- How to use
- Examples of using
ISNONTEXTformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
ISNONTEXTformula 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
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.
ISNONTEXTnot working? Here are some common mistakes people make when using the
ISNONTEXTGoogle 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.
The following functions are similar to
ISNONTEXT or are often used with it in a formula:
ISTEXTfunction 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.
ISNUMBERformula 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.
IFformula 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.
ANDfunction 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.
You can learn more about the
ISNONTEXT Google Sheets function on Google Support.