WallStreetMojo

WallStreetMojo

Home » Excel, VBA & Power BI » Excel Tutorials » ISNUMBER in Excel

ISNUMBER in Excel

By Tanuj KumarTanuj Kumar | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

ISNUMBER Function in Excel

ISNUMBER in excel is a logical function in excel which we use to find out that if the target or the cell being referred to is blank or not, the method of using this formula is =ISNUMBER ( Reference Cell) the argument reference cell is the cell which we want to check or identify, if we have for example =ISNUMBER (T1XT) the output is false as the argument does not only has numbers in it.

ISNUMBER Formula

ISNUMBER Formula in Excel

Parameters

As it is clear from the syntax shown above, the ISNUMBER Formula excel has only one parameter, which is explained below:

Value: The “Value” parameter is quite flexible; it can be another function or formula, a cell, or value in need of testing to be numeric.

The Formula excel returns:

True: If the “Value” parameter is a number or numerical,

False: If the “Value” parameter is not a number or numerical.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

This will be much clearer from the  following ISNUMBER function examples explained in the next section.

How to Use the ISNUMBER Function in Excel?

In this section, we will understand the uses of this function and will la ook at few examples the s with the help of actual data.

It is really easy to use, and as explained in the previous section, the ISNUMBER function uses only one mandatory parameter.

You can download this ISNUMBER Function Excel Template here – ISNUMBER Function Excel Template

Example #1

In this ISNUMBER function example, we will check a few values and test the behavior of the ISNUMBER function.

Example 1

Example #2

In this example, we will use some other functions as parameters for the ISNUMBER function.

Example 2

Things to Remember

  1. It can be used as a worksheet function.
  2. It returns a Boolean value (TRUE or FALSE).
  3. This function is a part of a group of functions of Excel, which is called the “IS Functions” group.

ISNUMBER in Excel Video

Recommended Articles

This has been a guide to ISNUMBER Function in Excel. Here we will learn how to use the ISNUMBER formula along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

0 Shares
Share
Tweet
Share
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>