ISNUMBER returns TRUE if a value is a number and FALSE otherwise. It is a simple test you can combine with IF, COUNTIF, or SEARCH to validate data and build reliable formulas.
=ISNUMBER(value)What does ISNUMBER do?
ISNUMBER is a small but powerful information function in Excel. It takes one value and tells you whether that value is a number. The result is either TRUE or FALSE. That is all it does, but that simple test is the foundation for many practical formulas.
Why does this matter? Excel treats numbers and text differently. A cell that looks like a number may actually be stored as text, which breaks calculations, sorting, and lookups. ISNUMBER lets you check the real data type before you rely on it. You can also use it to test the result of another formula, such as SEARCH, to see whether a piece of text was found.
Imagine you receive a monthly sales report and need to flag rows where the sales figure is missing or entered as text. With ISNUMBER you can write a formula that returns TRUE for valid numbers and FALSE for anything else. That makes it easy to filter, count, or highlight problem rows before you build a summary.
When to use ISNUMBER
- Checking whether imported data is stored as real numbers or as text.
- Flagging cells that contain errors or non-numeric entries before calculations.
- Testing whether SEARCH or FIND found a substring inside a text value.
- Counting how many cells in a range contain numbers with SUMPRODUCT.
- Validating user input in a form or template.
- Building conditional formatting rules that react only to numeric cells.
ISNUMBER syntax
=ISNUMBER(value)| Argument | Required? | What to enter |
|---|---|---|
value | Required | The value, cell reference, or expression you want to test. It can be a number, text, date, logical value, error, or a formula result. |
What it returns: TRUE if the value is a number; FALSE if it is text, a logical value, an error, or an empty cell.
ISNUMBER examples
1 Basic test: is the cell a number?
This example checks a short list of mixed values. The goal is to see how ISNUMBER reacts to numbers, text, and blanks. The formula =ISNUMBER(B2) looks at cell B2. Because B2 contains the number 150, the result is TRUE. If you copied the formula down, text values such as "N/A" would return FALSE.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Value | |||
| 2 | Apples | 150 | TRUE | ||
| 3 | Oranges | N/A | |||
| 4 | Bananas | 75 | |||
| 5 | Grapes | unknown | |||
| 6 | Pears | 220 | |||
| 7 |
2 Combine with IF to label valid numbers
This example turns the TRUE/FALSE result into a readable label. The goal is to mark each row as "Number" or "Not a number". The formula =IF(ISNUMBER(B2),"Number","Not a number") first tests B2 with ISNUMBER. If the test is TRUE, IF returns "Number"; otherwise it returns "Not a number". For B2, which contains 45, the result is "Number".
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Quantity | |||
| 2 | Pens | 45 | Number | ||
| 3 | Pencils | forty | |||
| 4 | Notebooks | 30 | |||
| 5 | Erasers | n/a | |||
| 6 | Rulers | 12 | |||
| 7 |
3 Test whether SEARCH found a substring
ISNUMBER is often paired with SEARCH to check whether a text contains a specific word. The goal is to see if the product description mentions "Pro". The formula =ISNUMBER(SEARCH("Pro",B2)) runs SEARCH first. SEARCH returns a number if it finds "Pro", or an error if it does not. ISNUMBER then converts that result to TRUE or FALSE. For B2, "Pro" is found, so the result is TRUE.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Description | |||
| 2 | Laptop | Ultrabook Pro 14 | TRUE | ||
| 3 | Mouse | Wireless mouse | |||
| 4 | Monitor | 27-inch Pro display | |||
| 5 | Keyboard | Mechanical keyboard | |||
| 6 | Dock | USB-C dock | |||
| 7 |
4 Count numeric entries in a range
This example counts how many cells in a range contain real numbers. The goal is to know how many valid scores were entered. The formula =SUMPRODUCT(--ISNUMBER(B2:B6)) applies ISNUMBER to each cell in B2:B6, producing an array of TRUE and FALSE values. The double negative converts TRUE to 1 and FALSE to 0, and SUMPRODUCT adds them up. Since B2, B3, B4, and B6 are numbers and B5 is text, the result is 4.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Score | |||
| 2 | Anna | 88 | 4 | ||
| 3 | Ben | 92 | |||
| 4 | Cara | 75 | |||
| 5 | Dan | absent | |||
| 6 | Eve | 81 | |||
| 7 |
Common ISNUMBER errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The value argument is an expression that cannot be evaluated, such as a malformed formula or an invalid range reference. | Check the argument for typos and make sure any nested formula is valid. Use a direct cell reference or a simple value to test. |
| Wrong result: FALSE for a date | Dates are stored as serial numbers in Excel, so ISNUMBER returns TRUE for a real date. If you see FALSE, the date is probably stored as text. | Convert the text date to a real date using DATEVALUE or Text to Columns, then test again. |
| Wrong result: FALSE for a number stored | A number with a leading apostrophe or imported as text is not a numeric value, so ISNUMBER returns FALSE. | Convert the text to a number with VALUE, multiply by 1, or use Text to Columns. Then ISNUMBER will return TRUE. |
| Unexpected TRUE for a logical value | ISNUMBER returns FALSE for TRUE and FALSE logical values, but if a formula returns 1 or 0 instead, ISNUMBER sees a number. | Check what the cell actually contains. Use ISTEXT or ISLOGICAL alongside ISNUMBER if you need to distinguish types. |
Tips for using ISNUMBER
- Use ISNUMBER with IF to turn TRUE/FALSE into friendly labels such as "Valid" and "Check".
- Pair ISNUMBER with SEARCH to test for substrings; SEARCH is case-insensitive, FIND is case-sensitive.
- To count numeric cells, use
=SUMPRODUCT(--ISNUMBER(range))rather than COUNTIF, which can behave differently with text-formatted numbers. - Remember that dates and times are numbers in Excel, so ISNUMBER returns TRUE for them.
- ISNUMBER returns FALSE for empty cells; use ISBLANK if you need to detect blanks separately.
- Combine ISNUMBER with conditional formatting to highlight non-numeric entries in a data range.
Frequently asked questions
What does ISNUMBER return for a date?
TRUE, because Excel stores dates as serial numbers. If the date is stored as text, ISNUMBER returns FALSE.
Does ISNUMBER work with text that looks like a number?
No. A value such as "123" stored as text returns FALSE. You must convert it to a real number first.
Can ISNUMBER check multiple cells at once?
ISNUMBER itself takes one value, but you can use it inside SUMPRODUCT or an array formula to test a range and count or sum the results.
Why does ISNUMBER return FALSE for an empty cell?
An empty cell is not a number, so ISNUMBER returns FALSE. Use ISBLANK if you need to test for emptiness.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ISNUMBER reference