The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISNONTEXT Function
Syntax
=ISNONTEXT(value)
Checks if the value, cell reference or formula return a cell that does not contain text.
Returns TRUE or FALSE
Returns TRUE if the value does not contain text
Returns FALSE if the value contains text
Examples
| A | B | C | D | E | F | |
| 2 | Cell references | Returned Values | ||||
| 3 | cell D3 is blank | =ISNONTEXT(D3) | TRUE | |||
| 4 | Star Trek | =ISNONTEXT(D4) | FALSE | |||
| 5 | 100 | 100 | =+B5=C5 | =ISNONTEXT(D5) | TRUE | |
| 6 | =+BogusRangeName | =ISNONTEXT(D6) | TRUE | |||
| 7 | =K7*#REF! | =ISNONTEXT(D7) | TRUE | |||
| 8 | ||||||
| 9 | Formulas | |||||
| 10 | 12 | 2 | =ISNONTEXT(B10/D10) | TRUE | ||
| 11 | 100 | 0 | =+B11/C11 | =ISNONTEXT(B11/D11) | TRUE | |
| 12 | Star | Trek | =ISNONTEXT(C12&D12) | FALSE | ||
| 13 | ||||||
| 14 | Values | |||||
| 15 | =ISNONTEXT("1000") | FALSE | ||||
| 16 | =ISNONTEXT(1000) | TRUE |
Categories: IS Functions