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
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 a value in need of testing to be numeric.
The Formula excel returns:
True: If “Value” parameter is a number or numerical,
False: If the “Value” parameter is not a number or numerical.
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 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.
Example #1
In this ISNUMBER function example, we will check a few values, and test the behavior of ISNUMBER function.
Example #2
In this example, we will use some other functions as parameters for the ISNUMBER function.
Things to Remember
- It can be used as a worksheet function.
- It returns a Boolean value (TRUE or FALSE).
- This function is a part of a group of functions of Excel, which is called “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 ISNUMBER formula along with excel example and downloadable excel templates. You may also look at these useful functions in excel –
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion
