How to use the ISNONTEXT function
What is the ISNONTEXT function?
The ISNONTEXT function returns TRUE if value is not text, also returns TRUE if cell is empty.
What is a Boolean value?
A Boolean value in Excel is a value that can only be TRUE or FALSE. It represents binary logic and is the result of a logical expression using logical operators or a result of a few Excel functions.
Mastering Boolean logic and logical expressions is key to manipulating data and controlling workflow in Excel.
What is nontext?
Excel tries to identify inserted values automatically, text values are left-aligned. Boolean values and error values are centered in cells, and numerical values are right-aligned.
Cells containing anything except text values evaluates to TRUE by the ISNONTEXT function. The ISNONTEXT function lets you check a value in a formula instead of visually identify values by their position in a cell.
Other IS functions
| Excel Function | Description |
|---|---|
| ISBLANK(value) | Returns TRUE if the value is empty, FALSE otherwise |
| ISERR(value) | Returns TRUE if the value is any error value except #N/A, FALSE otherwise |
| ISERROR(value) | Returns TRUE if the value is any error value, FALSE otherwise |
| ISEVEN(value) | Returns TRUE if the value is an even number, FALSE for odd numbers |
| ISFORMULA(reference) | Returns TRUE if the cell contains a formula, FALSE otherwise |
| ISLOGICAL(value) | Returns TRUE if the value is a logical value (TRUE/FALSE), FALSE otherwise |
| ISNA(value) | Returns TRUE if the value is the #N/A error, FALSE otherwise |
| ISNONTEXT(value) | Returns TRUE if the value is not text, FALSE if it is text |
| ISNUMBER(value) | Returns TRUE if the value is a number, FALSE otherwise |
| ISODD(value) | Returns TRUE if the value is an odd number, FALSE for even numbers |
ISNONTEXT function Syntax
ISNONTEXT(value)
ISNONTEXT function Arguments
| value | Required. The value you want to check if not text. |
ISNONTEXT function example
The image above shows a worksheet with values populated in column B, they are all left-aligned by me. The first cell B3 contains "A" which is a text value. The ISNONTEXT function returns FALSE because the value is a text value.
The second cell B4 contains "1" which is a numerical value. The ISNONTEXT function returns TRUE because the value is NOT a text value. The third cell B5 contains TRUE which is a boolean value. The ISNONTEXT function returns TRUE because the value is NOT a text value.
Cells B6 to B9 contain errors, the ISNONTEXT function returns TRUE because the value is NOT a text value.
Formula in cell C3:
The ISNONTEXT function is very useful to identify error values in arrays. Most Excel functions return the same error value, however, this function returns FALSE if it encounters an error.
Functions in 'Information' category
The ISNONTEXT function function is one of many functions in the 'Information' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form