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