## How to use the ISNUMBER function

*Article updated on April 17, 2018*

The ISNUMBER function checks if a value is a number, returns TRUE or FALSE.

Formula in cell D3:

=ISNUMBER(B3)

### Excel Function Syntax

ISNUMBER(*value*)

### Arguments

value |
Required. The value you want to check if it is a number. |

### Comments

The ISNUMBER function is really useful sometimes because it returns FALSE from error values as well. Most Excel functions return an error if they are fed with an error.

### Articles with the 'ISNUMBER' Function

The following 11 articles have formulas that contain the ISNUMBER function.

Lookup with multiple criteria and return multiple search results

Question: How do I search a list containing First name column and a last name column? I want to search […]Search for a text string and return multiple adjacent values

This article demonstrates array formulas that search for cell values containing a search string and returns corresponding values on the […]Filter unique distinct values if value contains specific string [Formula and Advanced Filter]

Table of contents Filter unique distinct values using a "contain" condition Filter unique distinct values using a "contain" condition (Advanced […]
Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

Question: I have a list that I add data to every day. I would like to find the largest number […]

This blog post describes how to filter text values and then numbers from a range. Array formula in B15: =INDEX(tbl, […]

Question: I want to extract all numeric values into a new column? Also all text values into another column? Answer: […]

The following formula in cell D3 counts cells with values stored as text. =SUMPRODUCT(ISTEXT(B3:B14)*1) In other words, cells containing nothing, errors, […]

The easiest way to check if a cell contains a specific text string is, in my opinion, the IF and […]

The picture above shows different values in column B and a formula in column C that tries to identifies the […]

### Functions in 'Information'

The ISNUMBER function function is one of many functions in the 'Information' category.

The CELL function gets information about the formatting, location, or the contents of a cell. The formula example above in […]

The INFO function returns information about the current operating environment, file path, number of active worksheets, Excel version etc. Excel […]

The ISBLANK function returns TRUE if the argument is an empty cell, returns FALSE if not. Excel Function Syntax ISBLANK(value) […]

The ISERR function returns TRUE if a cell returns an error, except error value #N/A. Formula in cell C6: =ISERR(B6) […]

The ISERROR function returns TRUE if a cell returns an error. Formula in cell D3: =ISERROR(B3) Excel Function Syntax ISERROR(value) […]

The ISFORMULA function returns TRUE if a cell contains a formula, FALSE if text, number or boolean value. Formula in […]

The ISLOGICAL function returns TRUE if value is boolean. A boolean value is either TRUE or FALSE. Formula in cell C3: […]

The ISNA function returns TRUE if value is a #N/A error. Formula in cell C3: =ISNA(B3) Excel Function Syntax ISNA(value) […]

The ISNONTEXT function returns TRUE if value is not text, also returns TRUE if cell is empty. Formula in cell […]

The ISNUMBER function checks if a value is a number, returns TRUE or FALSE. Formula in cell D3: =ISNUMBER(B3) Excel […]

The ISODD function returns TRUE if a cell contains an odd number, FALSE if even number. Formula in cell C6: […]

The ISREF function returns TRUE if value refers to a reference. Formula in cell C3: =ISREF(B3) Excel Function Syntax ISREF(value) […]

The ISTEXT function returns TRUE if value is text. Formula in cell C3: =ISTEXT(B3) Excel Function Syntax ISTEXT(value) Arguments value […]

The N function returns a value converted into a number. Formula in cell C3: =N(B3) The N function returns the […]

The NA() function returns the error value #N/A meaning "value is not available". Formula in cell B3: =NA() Excel Function […]

The SHEET function returns the sheet number of the cell reference sheet. Formula in cell D3: =SHEET(A1) Excel Function Syntax […]

The SHEETS function returns the number of sheets in a reference. It returns the number of sheets in a workbook if […]

Use TYPE to find out what type of data is returned by a function or formula. Formula in cell C3: […]