The ISNUMBER function
Returns TRUE if a value is a number and FALSE for anything else, including text that only looks like a number. Dates and times are numbers too.
Syntax
ISNUMBER(value)- value
- The cell, value or formula result to check.
Examples
D1=ISNUMBER(B2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Quantity | TRUE | |
| 2 | Pens | 12 | ||
| 3 | Erasers | 12 |
D1=ISNUMBER(B3)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Quantity | FALSE | |
| 2 | Pens | 12 | ||
| 3 | Erasers | 12 |
C1=ISNUMBER(SEARCH("pro",A2))
| A | B | C | |
|---|---|---|---|
| 1 | Product | TRUE | |
| 2 | Laptop Pro 14 |
Practice ISNUMBER
Read the guide
Questions
How do I check if a cell contains a word?
Use =ISNUMBER(SEARCH("word",A2)). SEARCH returns the position of the word or
Why does ISNUMBER say FALSE when the cell shows a number?
The number is stored as text, which often happens with imported or pasted data. Convert it with VALUE, or multiply it by 1, and ISNUMBER returns TRUE.