ISNUMBER
Returns TRUE if a value is a number.
How it’s written
ISNUMBER(value)Example
| A | |
|---|---|
| 1 | Amount |
| 2 | n/a |
=ISNUMBER(A2)Result: FALSE
n/a is text, so the result is FALSE.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Good for finding text hiding in a number column.
Practice it properly
Handling errors and gaps gives you real tasks, with your formulas tested on data you haven’t seen.