Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ISNUMBER
ISNUMBER returns TRUE when a value is numeric and FALSE otherwise. Combined with IF or used as a flag, it helps catch text that should be a number.
Excel
=ISNUMBER(A2)Google Sheets
=ISNUMBER(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value |
| 42 |
=ISNUMBER(A2)→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the cell to test.
- 2ISNUMBER returns TRUE for numbers, FALSE for text.
- 342 is a number, so the result is TRUE.