Reference > Fathom Operators, Functions, and Units > Logical Functions

Logical Functions

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. 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: 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.

Key Curriculum Press/Key College Publishing
www.keypress.com/fathom