Formulas and Functions

155
The logical and information functions help you to evaluate
the contents of cells and help in determining how to
evaluate or otherwise work with cell contents or formula
results.
Listing of Logical and Information Functions
iWork provides these logical and information functions for use with tables.
Function Description
“AND” (page 156) The AND function returns TRUE if all arguments
are true, and FALSE otherwise.
“FALSE” (page 15 7 ) The FALSE function returns the Boolean value
FALSE. This function is included for compatibility
with tables imported from other spreadsheet
applications.
“IF” (page 15 8 ) The IF function returns one of two values
depending on whether a specied expression
evaluates to a Boolean value of TRUE or FALSE.
“IFERROR” (page 15 9 ) The IFERROR function returns a value that you
specify if a given value evaluates to an error;
otherwise it returns the given value.
“ISBLANK” (page 160) The ISBLANK function returns TRUE if the
specied cell is empty and FALSE otherwise.
“ISERROR” (page 161) The ISERROR function returns TRUE if a given
expression evaluates to an error and FALSE
otherwise.
7
Logical and Information Functions