ISNUMBER Function (Table of Contents).
ISNUMBER in Excel
IsNumber is another Boolean type of function in excel which gives the output in TRUE and FALSE only. IsNumber function in excel is used to find whether a cell contains a numerical value or a number. If any cell contains a number stating from 0 to any digit then IsNumber will return TRUE there or else for other than the number it will return FALSE.
Uses of ISNUMBER Function
ISNUMBER Function returns TRUE if a cell contains a number, otherwise, it returns FALSE. If a cell contains a TEXT, the function will return a FALSE. A cell contains a number or not, or if we want to check the result of any function is number, in these scenarios, we use ISNUMBER Function.
ISNUMBER Formula in Excel
Below is the ISNUMBER Formula in Excel :
Where the passing argument is:
- Value – The value which you want to check.
- The ISNUMBER function returns TRUE if a value is a valid number.
- The ISNUMBER function returns FALSE if the value is not a valid number like text, date, time, etc.
As a Worksheet function, it can be entered as a part of a formula in a cell. Thus, it can be used as below screenshot:
Where it is Found in Excel?
ISNUMBER Function is a built-in function in excel, hence it is found under FORMULAS tab in excel. Please follow the below steps:
- Click on the FORMULAS tab.
- Select More Functions option.
- It will open a drop-down list of functions category. Click on the Information tab.
- After clicking on the Information tab, it will again open a drop-down list of functions. Click on ISNUMBER function.
- It will open a dialog box for Function arguments.
- Enter the Value field with the value, which you want to check.
How to Use ISNUMBER Function in Excel?
This function is very simple and easy compared to other functions in Microsoft Excel which contains lots of arguments or parameters.
We have given below data.
Now we will apply ISNUMBER function on the above data:
The Result will be :
Drag & drop this formula for the rest data and the final result is shown below:
- If the supplied argument or value is a number, the ISNUMBER function will return TRUE. Like for value = 150, ISNUMBER(150) will return TRUE.
- If the value is text, character, sentence, special character, or any value other than a number, the ISNUMBER function will return FALSE. Like for Value = “$”, ISNUMBER($) will return FALSE.
Let’s take some mathematical expression:
Now we will apply the ISNUMBER Function on above expressions to check, that the result of these expressions is numeric or not.
The Result will be :
Apply the same rule for the rest values and the final result is shown below:
- The supplied value is the mathematical expression, hence the ISNUMBER function return as TRUE.
Things to Remember
- If supplied value is Excel date and time, the ISNUMBER function will return TRUE, because they are numeric.
- If a value is text or supplied number is entered as text, the ISNUMBER function will return FALSE.
- Where there is a large amount of data, the ISNUMBER is very helpful. It helps in testing if the result of any function is a number or not.
- The ISNUMBER function is a part of IS Functions that return TRUE or FALSE.
- This function will never return any error value like #NAME!, #N/A! etc.
This has been a guide to ISNUMBER Function in Excel. Here we discuss the ISNUMBER Formula in Excel and How to use ISNUMBER function in Excel along with practical examples and downloadable excel templates. You can also go through our other suggested articles –