156 and – Apple iWork '09 User Manual
Page 156
Function
Description
The ISEVEN function returns TRUE if the value is
even (leaves no remainder when divided by 2);
otherwise it returns FALSE.
The ISODD function returns TRUE if the value
is odd (leaves a remainder when divided by 2);
otherwise it returns FALSE.
The NOT function returns the opposite of the
Boolean value of a specified expression.
The OR function returns TRUE if any argument is
true; otherwise it returns FALSE.
The TRUE function returns the Boolean value
TRUE. This function is included for compatibility
with tables imported from other spreadsheet
applications.
AND
The AND function returns TRUE if all arguments are true, and FALSE otherwise.
AND(test-expression, test-expression…)
Â
test-expression: An expression. test-expression can contain anything as long as the
expression can be evaluated as a Boolean. If the expression evaluates to a number, 0
is considered to be FALSE, and any other number is considered to be TRUE.
Â
test-expression…: Optionally include one or more additional expressions.
Usage Notes
The AND function is equivalent to the logical conjunction operator used in
Â
mathematics or logic. It first evaluates each test-expression. If all the given
expressions evaluate to TRUE, the AND function returns TRUE; otherwise FALSE.
Examples
=AND(TRUE, TRUE) returns TRUE because both arguments are true.
=AND(1, 0, 1, 1) returns FALSE because one of the arguments is a numeric 0, which is interpreted as
FALSE.
=AND(A5>60, A5<=100) returns TRUE if cell A5 contains a number in the range 61 to 100, otherwise
FALSE.
The following two IF functions will return the same value:
=IF(B2>60, IF(B2<=100, TRUE, FALSE), FALSE)
=IF(AND(B2>60, B2<=100), TRUE, FALSE)
156
Chapter 7
Logical and Information Functions