The following article introduces you to the ISNUMBER function - one of the functions in the information function group is very popular in Excel.
Description: The function returns True if the value is numeric. Use the function to check if the value is numeric or not.
Syntax: ISNUMBER (value)
Inside:
- value: The value you want to check is a numeric value or not, is a required parameter.
Attention:
- The function returns True if the value is a numeric value and vice versa, the function returns False.
- Where value is a logical value or a blank value -> the function returns False value .
For example:
Determine whether the values in the value are numerical or not.
- In the cell to calculate enter the formula : = ISNUMBER (C6)
- Press Enter -> return value is:
- Here cell C6 is a numeric value, not a text value, so the function returns True.
- Similarly copying the formula for the remaining values results:
- Where value is a logical value or a blank value -> the function returns False value .
Above are instructions and some specific examples when using the ISNUMBER function in Excel.
Good luck!