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 191
Performing Arithmetic Operations
To create a formula that performs an arithmetic operation, you use arithmetic
operators. For example, to add the values in two columns, you could create a formula
that looks like this: A2 + A3 + A5.
Here are the basic arithmetic operators. For complete information about operators
that Pages supports, see “Defining Formulas That Use Operators” on page 193.
To add an arithmetic formula to a cell:
1 Select an empty cell for displaying the results of the formula.
2 Open the Formula Editor. For example, type an equal sign (=).
3 Enter the formula in the text field following the equal sign. For example, to enter the
formula A3 * B5 + B6, in the text field following the equal sign you could:
a Click or type A3.
b Type * (the multiplication operator).
c Click or type B5.
d Click B6 (if you don’t type an operator before clicking, the Formula Editor adds the
plus sign (+) automatically).
4 Click the Accept button or press Return or Enter to save the formula.
Using Predefined Functions
The Insert Formula button in the Formula Editor lets you quickly add a function to a
formula.
When you use a function, you name the function and, in parentheses following the
name, you provide the arguments it needs. Arguments specify the data the function
will use when it performs its operations.
To perform this operation Use this arithmetic operator For example
Sum two values + A2 + B2
Subtract one value from
another value
– A2 – B2
Multiply two values * A2 * B2
Divide one value by another
value
/ A2 / B2