The `ISNONTEXT` function in Excel is used to check whether a given cell or value is not text. It returns `TRUE` if the cell contains a non-text value (like a number, error, or blank cell), and `FALSE` if it contains text.
Syntax
ISNONTEXT(value)
- value: The value or cell reference you want to test.
How to Use ISNONTEXT
=ISNONTEXT(A1)
=ISNONTEXT(123)
- Open Excel: Start your Excel application and open your workbook.
- Select a Cell for the Formula: Click on the cell where you want the result of the `ISNONTEXT` function to appear.
- Enter the Formula: You can directly type the formula or select values via the formula bar. For example:
- If you want to check cell A1:
- If you want to check a direct value like a number:
- Press Enter: After you have typed the formula, press Enter. The cell will display `TRUE` if the tested value is not text and `FALSE` if it is text.
Examples
=ISNONTEXT(A1)
- Example 1: If cell A1 contains the number 10, then:
This will return `TRUE`.
=ISNONTEXT(B2)
- Example 2: If cell B2 contains the text “Hello”, then:
This will return `FALSE`.
=ISNONTEXT(500)
- Example 3: Testing a direct number:
This will return `TRUE`.
=ISNONTEXT("Excel")
- Example 4: Testing a direct string:
This will return `FALSE`.
Tips
=IF(ISNONTEXT(C1), "This is not text", "This is text")
- Combining with Other Functions: Combine `ISNONTEXT` with other functions (like `IF`) to create logical tests. For instance:
- Useful for Data Validation: `ISNONTEXT` can be helpful in data validation checks, ensuring that certain cells contain only numbers or other non-text data types.
Remember that `ISNONTEXT` will return `TRUE` for blank cells, as a blank value is considered a non-text value in Excel.
Unlock Your Potential
Excel
Access
Power BI
