Indicates whether the specified value is a number by returning True or False.
IsNumber([Value],[Allow strings])
Where:
Value is the value, or reference to a value, to test.
Allow strings (optional) is whether or not string values can be counted as numbers.
Rule | Meaning |
|---|---|
| IsNumber(OrderNumberReturn) | Checks the return value of OrderNumber and if it is a number. As long as this is not a string, the IsNumber function will return TRUE. |
| IsNumber(OrderNumberReturn,True) | Checks the return value of OrderNumber and if it is a number, or a number in a string, the IsNumber function will return TRUE. |
| Value | Outcome |
|---|---|
| "Engine" | False |
| 29 | True |
| "29" | Will return False, when Allow strings is False (or not given).
Will return True, when Allow strings is True. |
| NOW() | True |
| TRUE | False |