even
|
Returns true if the argument is even: even(10) returns true; even(11) returns false. If the argument is not an integer, you will get a #DOMAIN# error.
|
exists
|
True if the value exists for the indicated attribute: exists(pressure) will be true for each case for which there is a value for pressure.
|
includes
|
Takes two arguments and returns true if the second argument is a substring of the first (also treated as a string): includes("the", "he") returns true; includes("dancing", "joy") returns false; includes(1234, 23) returns true.
|
inRange
|
True when a number is in a given range: inRange(height, 60, 66) will be true for people whose height is greater than or equal to 60 and less than 66. Otherwise, assuming the arguments are numeric, the result will be false.
|
isNumber
|
True if the value is numeric: isNumber(date) will be true for the value 27 but false for the value June.
|
isPrime
|
True if the value is a prime integer: isPrime(1234567) is false; isPrime(1234577) is true. The argument can be as big an integer as your computer can represent, probably about 15 digits.
|
missing
|
True if the value is missing (there is no value for that cell); false if there is a value present.
|
odd
|
Returns true if the argument is odd. odd(15) returns true. odd(20) returns false. If the argument is not an integer, you will get an error.
|
