2
Table Of Contents
- User’s Guide
- Contents
- Welcome to Pages
- Overview of Pages
- Creating a Document Using the Pages Templates
- Formatting a Document’s Layout and Table of Contents
- Setting Page Orientation and Size
- Setting Page Margins
- Creating Columns
- Varying Column and Page Layouts
- Creating a Document With Left- and Right-Facing Pages
- Adding Headers, Footers, Page Numbers, Footnotes, and Endnotes
- Varying Document Formatting Using Section Breaks
- Adding a Repeated Background Image
- Using a Table of Contents
- Formatting Text and Paragraphs
- Working With Styles
- Working With Graphics andOther Media
- Changing Object Properties
- Creating Tables
- Adding a Table
- Using Table Cells and Borders
- Formatting Tables
- Adding Images or Background Colors
- Formatting Numbers
- Sorting Cells
- Autofilling
- Using Formulas
- A Tour of Using Formulas
- Adding a Quick Formula
- Removing a Formula
- Using the Formula Editor to Add and Edit Formulas
- Using Cell References
- Adding a Formula to Multiple Cells
- Performing Arithmetic Operations
- Using Predefined Functions
- Operators and Functions for Advanced Table Formula Users
- Defining Formulas That Use Operators
- Defining Formulas That Use Functions
- Creating Charts
- Personalizing Documents With Address Book Data
- Printing and Exporting Your Document to Other Formats
- Designing Your Own Document Templates
- Index
Chapter 8 Creating Tables 197
Logical functions determine whether a particular condition is TRUE or FALSE.
This function Returns Examples Notes
AND(x
1
...) TRUE if all the
arguments are TRUE,
otherwise returns
FALSE
AND(TRUE, TRUE)
returns TRUE
AND(TRUE, FALSE)
returns FALSE
AND(TRUE, 0) returns
FALSE
See note at end of
table.
ISERROR(x) TRUE if x is erroneous,
otherwise returns
FALSE
ISERROR(1/0) returns
TRUE
NOT(x) TRUE if x is FALSE
FALSE if x is TRUE
NOT(TRUE) returns
FALSE
NOT(FALSE) returns
TRUE
Interprets 0 as FALSE
and all other numbers
as TRUE
OR(x
1
...) TRUE if any argument
is TRUE, otherwise
returns FALSE
OR(TRUE, FALSE)
returns TRUE
OR(FALSE) returns
FALSE
See note at end of
table.
Notes:
 If an argument of AND or OR is a reference to a cell that doesn’t contain
TRUE or FALSE, the argument is ignored. When you type arguments, rather
than referring to cells for values, zero is interpreted as FALSE, any other number
is interpreted as TRUE, and text strings result in an error.