Returns TRUE if the value is a number.
- value - The value to be checked.
ISNUMBER("Spreadsheet") evaluates to FALSE.
ISNUMBER(12) evaluates to TRUE.
ISNUMBER(C5) checks if the value contained in C5 is a number.
- Numeric values that are enclosed in double quotation marks are treated as text. So, while ISNUMBER(12) evaluates to TRUE, ISNUMBER("12") evaluates to FALSE.