## What is ISNUMBER function in Excel?

The** ISNUMBER **function is one of the **Information** functions of Excel.

It Checks whether a **value is a number**, and returns TRUE or FALSE.

We can find this function in **Information** of insert function Tab.

## How to use ISNUMBER function in excel?

- Click on an
**empty cell**(like F5).

2. Click on the **fx icon **(or press **shift+F3**).

3. In the **insert function tab** you will see all functions.

4. Select **Information** category.

5. Select **ISNUMBER **function

6. Then select **ok**.

7. In the function arguments Tab you will see **ISNUMBER **function.

8. Value section is the **value **you want to be **tested**. Value can refer to a cell, a formula, or a name that **refers **to a cell, formula, or value.

9. You will see the **results **in the formula result section.

## Examples of ISNUMBER function in Excel

**Example1:**

**How to check if data is number in Excel?**

In the following examples, as you can see in the photo, numbers can be identified by the **ISNUMBER** function.

`=`**ISNUMBER**(0.2) ----->>>>answer is TRUE
=**ISNUMBER**(PI()) ----->>>>answer is TRUE
=**ISNUMBER**(#REF) ----->>>>answer is FALSE
=**ISNUMBER**(1.5) ----->>>>answer is TRUE
=**ISNUMBER**() ----->>>>answer is FALSE
=**ISNUMBER**("MAY") ----->>>>answer is FALSE
=**ISNUMBER**(350) ----->>>>answer is TRUE

**Example2:**

**If a cell contains a formula**:

If the answer is a number, the result will be true, otherwise, the result will be false.

`=`**ISNUMBER**(2^2) ----->>>>answer is TRUE
=**ISNUMBER**(PI()) ----->>>>answer is TRUE
=**ISNUMBER**(2+2) ----->>>>answer is TRUE
=**ISNUMBER**(TRUE) ----->>>>answer is FALSE
=**ISNUMBER**(2*TRUE) ----->>>>answer is TRUE
=**ISNUMBER**(FALSE*TRUE) ----->>>>answer is TRUE
=**ISNUMBER**(350/35) ----->>>>answer is TRUE

**Example3:**

**how to count numeric values in excel**?

In the following examples, as you can see in the photo, we can **count numeric values** by the **ISNUMBER** and SUMPRODUCT functions.

`=SUMPRODUCT(--ISNUMBER(`**A1:E10**)) ----->>>>answer is **36**

**Example 4:**

**If a cell contains a date**:

ISNUMBER will return TRUE for Excel dates since they are numeric.

`=`**ISNUMBER**(date) ----->>>>answer is TRUE

**Example 5:**

**If a cell contains a Time**:

ISNUMBER will return TRUE for Excel times since they are numeric.

`=`**ISNUMBER**(time) ----->>>>answer is TRUE

**Example 6:**

**If a cell contains nothing**:

`=`**ISNUMBER**() ----->>>>answer is FALSE

## ERROR in ISNUMBER function

The output of this function is either false or true and never displays an error.

## ISNUMBER related functions

- Use ISBLANK function to check whether a reference is to an empty cell, and return TRUE or FALSE.
- Use ISFORMULA function to check whether a reference is to a cell containing a formula.
- Use ISLOGICAL function to check whether a value is a logical value, and returns TRUE or FALSE.
- Use ISNONTEXT function to check whether a value is not text, and returns TRUE or FALSE.