IsNumber
Returns whether or not each value passed in is a number. When multiple values are passed in, it returns an array of true/false values which can be passed into the And() and Or() functions.
Syntax
IsNumber(value, [value], ...)
Example
| Formula | Results |
|---|---|
| =IsNumber("5") | true |
| =And(IsNumber("5", "not number")) | false |
| =Or(IsNumber("5", "not number")) | true |
Updated almost 2 years ago