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. For example, exists(pressure) will be true for each case for which there is a value for pressure.
|
includes
|
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. For example, inRange(height, 60, 66) will be true for people whose height is greater than or equal to 60 and less than 66. If the third argument is less than or equal to the second argument, you will get an error.
|
isNumber
|
True if the value is numeric. For example, 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.
|
