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 193
For example, to refer to nine cells in column A (A2 through A10), you could drag from
cell A2 to cell A10. You can also:
a Click or type A2.
b Type a colon.
c Click or type A10.
5 Click the Accept button or press Return or Enter to save the formula.
Operators and Functions for Advanced Table Formula Users
After becoming familiar with the Formula Editor and cell references, you can create a
wide variety of formulas.
The remainder of this chapter fully describes the operators and functions that you can
include in your formulas when you type them in the text field of the Formula Editor.
Defining Formulas That Use Operators
You use operators in formulas when you want to perform arithmetic or comparison
operations:
 A2 + A3. This formula adds the values in two cells of the first column.
 A2 > B6. This formula determines whether the value in cell A2 is larger than the
value in cell B6. If it is, the result is TRUE; otherwise, it is FALSE.
Arithmetic operators perform arithmetic and return numerical results.
This operator Returns
Example (A2 contains 20 and
B2 contains 2)
+ The sum of two values A2+B2 returns 22
– The difference between two
values
A2–B2 returns 18
* The product of two values A2*B2 returns 40