Apple numbers User Manual
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.
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
Returns TRUE if all arguments are true and FALSE otherwise.
Returns the value FALSE for compatibility with older spreadsheet
applications.
applications.
Returns one of two values depending on whether a specified
expression is TRUE or FALSE.
expression is TRUE or FALSE.
Returns the negation of an expression’s Boolean value.
Returns TRUE if any argument is true.
Returns the value TRUE for compatibility with older spreadsheet
applications.
applications.
Function
Description
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.
to an error and FALSE otherwise.
Returns TRUE if the value is even and FALSE otherwise.
Returns TRUE if the value is odd and FALSE otherwise.