How do I use ISNUMBER in Excel?
Use ISNUMBER when you want to check whether a value is numeric. Enter Value in that order, then add optional arguments when needed.
Excel Function
ISNUMBER
Checks whether value is a number.
ISNUMBER(value)Arguments
value
RequiredSpecify a single cell reference.
Practice Preview
Use ISNUMBER to check whether cell A2 (Value 1 in column A) holds a number.
Example Table
| # | AValue 1 | BValue 2 | CValue 3 | DResult |
|---|---|---|---|---|
| 2 | 120 | Text | ||
| 3 | 98.5 | 100 | ||
| 4 | 0 | N/A | ||
| 5 | 45 | Test | ||
| 6 | ||||
| 7 | ||||
| 8 |
How to Use (Formula)
=ISNUMBER(A2)Result
TRUE
Practice This Function
ISNUMBER FAQ
Where can I practice ISNUMBER?
Use the "Start Function Practice" button to jump straight into ISNUMBER drills.
What arguments does ISNUMBER use?
The main arguments are Value. Enter them in order.