How to Use the ISNUMBER Function in Google Sheets
=ISNUMBER(value). A number in quotation marks is text, so it returns FALSE.
What ISNUMBER does
ISNUMBER answers one question: is this a real number? It helps you find cells that look numeric but are text, which are the usual cause of sums that come out too small and lookups that fail.
ISNUMBER syntax
=ISNUMBER(value)
Per Google's help page, it returns TRUE if the value is a number or a reference to a cell containing a numeric value, and FALSE otherwise. It is most often used with IF. The page notes that a number enclosed in quotation marks returns FALSE: ISNUMBER("123") is FALSE because the input is text.
A step-by-step example
Cell A2 holds the number 42.
| A | |
|---|---|
| 1 | Value |
| 2 | 42 |
=ISNUMBER(A2)
This returns TRUE. In the same way =ISNUMBER(4) is TRUE and =ISNUMBER("123") is FALSE.
Find numbers stored as text
If a column of numbers refuses to add up, test it. A cell where ISNUMBER returns FALSE even though it looks like a number holds text. The VALUE function converts it into a real number.
Common mistakes
- Trusting what the cell looks like. Alignment is a hint: text usually sits on the left, numbers on the right.
- Forgetting quotes make text. Anything inside quotation marks is text.
- Treating dates as separate. A real date is stored as a number, so ISNUMBER on a date cell is TRUE.
Try it yourself
Use the cell above (A2). Type your formula into the box, starting with =, then press Check.
Exercise 1: Is it a number?
Write a formula that checks whether the value in A2 is a number.
Exercise 2: Number in quotes
Write a formula that tests the typed text "123" (in quotation marks) and returns FALSE.
What to learn next
- VALUE: turn text into a number.
- ISBLANK: check whether a cell is empty.
- IF: run a test and return one of two results.
Syntax and rules in this guide were checked against Google's ISNUMBER help page. See all guides.