Apple numbers User Manual

    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.

  

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.

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.

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.

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.