Excel ISNUMBER function

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?

1. 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.

Related posts:

Excel QUOTIENT Function TRANSPOSE Function in Excel Excel YEARFRAC Function Hide a formula in excel