Apple Numbers '08 - Manual (Page 198)

198 Chapter 12 Dictionary of Functions
Logical Functions
The logical functions evaluate the logical truth or falsehood of expressions and return
TRUE, FALSE, or a value assigned by the function.
Numbers provides these logical functions.
Information Functions
Information functions return information about the contents of a cell or argument.
Numbers provides these information functions.
Function Description
AND (page 208) Returns TRUE if all arguments are true and FALSE otherwise.
FALSE (page 231) Returns the value FALSE for compatibility with older spreadsheet
applications.
IF (page 236) Returns one of two values depending on whether a specified
expression is TRUE or FALSE.
NOT (page 252) Returns the negation of an expression’s Boolean value.
OR (page 255) Returns TRUE if any argument is true.
TRUE (page 283) Returns the value TRUE for compatibility with older spreadsheet
applications.
Function Description
ISBLANK (page 240) Returns TRUE if the specified cell is empty and FALSE otherwise.
ISERROR (page 241) Returns TRUE if the expression in the function’s argument evaluates
to an error and FALSE otherwise.
ISEVEN (page 241) Returns TRUE if the value is even and FALSE otherwise.
ISODD (page 241) Returns TRUE if the value is odd and FALSE otherwise.