The Excel Spreadsheet Excelclopedia
Printable ViewExcel ISNUMBER Function
Syntax
=ISNUMBER(value)
Checks if the value, cell reference or formula returns a number
Returns TRUE or FALSE
Returns TRUE if the value is anumber
Examples
| A | B | C | D | E |
| 2 | Cell references | Returned Value | ||
| 3 | 1701 | =ISNUMBER(C3) | TRUE | |
| 4 | 0 | =ISNUMBER(C4) | TRUE | |
| 5 | =12/6 | =ISNUMBER(C5) | TRUE | |
| 6 | =12/0 | =ISNUMBER(C6) | FALSE | |
| 7 | Excel Wiki | =ISNUMBER(C7) | FALSE | |
| 8 | cell C8 is blank | =ISNUMBER(C8) | FALSE | |
| 9 | ||||
| 10 | Formulas | |||
| 11 | 1701 | 2 | =ISNUMBER(B11+C11) | TRUE |
| 12 | 1701 | 0 | =ISNUMBER(B12/C12) | FALSE |
| 13 | Excel | Wiki | =ISNUMBER(B13&C13) | FALSE |
| 14 | ||||
| 15 | Values | |||
| 16 | =ISNUMBER("abc") | FALSE | ||
| 17 | =ISNUMBER("1000") | FALSE |
Categories: IS Functions