The ISNUMBER function checks if the value is a number.
Returns TRUE if it is and FALSE if not.
This function can be useful for validating data and processing various types of input values.
Syntax
ISNUMBER(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value that is checked for whether it is a number or not |
Any value (number, text, formula, cell reference, and so forth) |
Examples of use
Checking the value in a cell
=ISNUMBER(A1)
If cell A1 contains a number, the function returns TRUE.
If A1 contains text or is empty, FALSE will be returned.
Use in a conditional formula
=IF(ISNUMBER(B1), "This is a number", "This is not a number")
If the value in cell B1 is a number, the function returns “This is a number”; otherwise, it returns “This is not a number.”
Notes
Please note that the function recognizes number formats such as dates and monetary amounts as numbers.