ISNUMBER
The ISNUMBER function tests a text object to determine whether it contains all numeric characters.
- Syntax:
- ISNUMBER (single-text-expression)
- Meaning:
- ISNUMBER (text_to_test)
- Returns:
- This function evaluates to a Boolean "true" or "false" and should only be used as a conditional expression within a logical function.
If text_to_test contains only digits (for example, 0-9), ISNUMBER evaluates to "true".
If text_to_test contains other than digits, ISNUMBER evaluates to "false".
Examples
IF(ISNUMBER("1")
Returns "true"
Related functions
|
|
|
|
|
|
|