## How to use ISNUMBER function in Excel

The ISNUMBER function is a built-in function of **IS** series (group) in Excel. **ISNUMBER** returns the value of a cell, whether is a numeric or text. If the value of a cell is numeric then it will return as TRUE else FALSE.

**ISNUMBER **is a Boolean function always gives the result as a TRUE or FALSE format.

## Syntax of ISNUMBER function

#### ISNUMBER (Value)

## Arguments of the function

**Value –** Value refers to a number

In the below example we will apply ISNUMBER function to know that how it works. Where cell “A2” has a numeric value (15) and cell “A3” has a text value (hello). Now apply the formula in cell B2 and B3.

See below image where cell C2 result is TRUE and cell C3 result is FALSE.

This function will return TRUE – if the value is numeric

This function will return FALSE – if the value is text

## Combining ISNUMBER function with IF

In the below example, left side we have a name column and in the right column its value. So to find out the value in the result column. Whether this value is a numeric or text one.

Here we will apply a combination of ISNUMBER with IF. How to apply the formula?

First, we will write IF function:-

Now put cell address (B2) with ISNUMBER function such as ISNUMBER(B2).

Combining with IF, see image below:-

Now “value_if_true” and “value_if_false” will be “Numeric Value” and “Text Value”.

The complete formula entered in a cell, see below image:-

The result of a cell (B2) is “Text Value” as the cell (B2) has text data and cell (B3) result is “Numeric Value” as the cell (B3) has a numeric data.

### Important notes

This function will count DATE and TIME function as TRUE and FALSE for the text value.

We can add more function to ISNUMBER function.

### Related Post