ISNUMBER
Numerical Information Functions
Basic Description
The Excel Isnumber function tests if a supplied value is a number. If so, the function returns TRUE; Otherwise it returns FALSE.
The syntax of the function is:
ISNUMBER( value )
Where the supplied 'value' argument can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.
Isnumber Function Examples
The spreadsheets below show examples of the Excel Isnumber function. The spreadsheet on the left shows the formulas used, and the spreadsheet on the right shows the results:
|
Formulas:
|
Results:
|