How to Use the ISNUMBER Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 4 min read · includes 2 free exercises

In short: ISNUMBER returns TRUE if a value is a number and FALSE otherwise. The formula is =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
1Value
242
=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

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.

Hint: pass the cell reference.

Exercise 2: Number in quotes

Write a formula that tests the typed text "123" (in quotation marks) and returns FALSE.

Hint: keep the quotation marks.

What to learn next

Syntax and rules in this guide were checked against Google's ISNUMBER help page. See all guides.