Apple Numbers '08 - Manual (Page 208)

208 Chapter 12 Dictionary of Functions
 table: Optional; the name of the table. If the table is on another sheet, you must also
include the name of the sheet.
AND
The AND function returns TRUE if all arguments are true and FALSE otherwise (logical
conjunction).
AND(expression, [expression, . . .])
 expression: A logical or numeric expression, or a reference to a cell containing such
an expression.
Notes
If expression is numeric, a value of 0 is interpreted as FALSE and any nonzero value is
interpreted as TRUE.
AREAS
The AREAS function counts the number of ranges the function references.
AREAS(ranges)
 ranges: One or more ranges of cells. To specify more than one range, enclose the
references in a second set of parentheses.
Examples
ADDRESS(3,5) creates the address $E$3.
ADDRESS(3,5,2) creates the address E$3.
ADDRESS(3,5,3) creates the address $E3.
ADDRESS(3,5,4) creates the address E3.
ADDRESS(3,3,,, “Sheet 2 :: Table 1”) creates the address Sheet 2 :: Table 1 :: $C$3.
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>50,A5<100) returns TRUE if cell A5 contains a number between 50 and 100.