ISNUMBER Function - Excel
Overview
The ISNUMBER function in Excel is a useful tool for checking if a specified value is a numeric data type. This function will return a TRUE value output if the specified value is a number and it will return a FALSE value output if it is not.
Example:
=ISNUMBER(1)
Syntax:
=ISNUMBER(value)
value: This is the value or reference to the cell or expression you want to check for being a number.
TRUE Example
In this example, the ISNUMBER function gives us a TRUE value result because C2 equals 1 which is a numeric data type.
FALSE Example
In this example, the ISNUMBER function gives us a FALSE value result because C2 equals “Apple” which is not a numeric data type.
