Formulas and Functions
ISNUMBER
The ISNUMBER function returns the boolean value TRUE if the given expression evaluates to a number; otherwise it returns the boolean value FALSE.
ISNUMBER(cell)
cell: The value to test. If the value can’t be interpreted as a single value, ISNUMBER returns an error.
Examples |
|---|
If the table cell A1 contains a number (100) and cell B1 contains a string ("Hello"): =ISNUMBER(A1) returns TRUE. =ISNUMBER(B1) returns FALSE. |