MS Excel: IsNumber Function
In Excel, the IsNumber function can be used to check for a numeric value.
The syntax for the IsNumber function is:
IsNumber( value )
value is the value that you want to test. If value is a numeric value , this function will return TRUE. Otherwise, it will return FALSE.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=IsNumber(A1) would return TRUE =IsNumber(A2) would return TRUE =IsNumber(A3) would return TRUE =IsNumber(A4) would return FALSE =IsNumber(5) would return TRUE =IsNumber("5") would return FALSE