Apple Keynote 3 - Manual (Page 122)

122 Chapter 5 Creating Tables
Logical functions determine whether a particular condition is TRUE or FALSE.
This function Returns Examples Notes
AND(x
1
...) TRUE if all the
arguments are TRUE,
otherwise returns
FALSE AND(TRUE, TRUE)
returns TRUE
AND(TRUE, FALSE)
returns FALSE
AND(TRUE, 0) returns
FALSE See note at end of
table.
ISERROR(x) TRUE if x is erroneous,
otherwise returns
FALSE ISERROR(1/0) returns
TRUE
NOT(x) TRUE if x is FALSE
FALSE if x is TRUE NOT(TRUE) returns
FALSE
NOT(FALSE) returns
TRUE Interprets 0 as FALSE
and all other numbers
as TRUE
OR(x
1
...) TRUE if any argument
is TRUE, otherwise
returns FALSE OR(TRUE, FALSE)
returns TRUE
OR(FALSE) returns
FALSE See note at end of
table.
Notes:
 If an argument of AND or OR is a reference to a cell that doesn’t contain
TRUE or FALSE, the argument is ignored. When you type arguments, rather
than referring to cells for values, zero is interpreted as FALSE, any other number
is interpreted as TRUE, and text strings result in an error.