Apple iWork '09 - Manual (Page 3)

13 Preface: Welcome to iWork Formulas & Functions
15
Chapter 1: Using Formulas in Tables
15 The Elements of Formulas
17 Performing Instant Calculations in Numbers
18 Using Predefined Quick Formulas
19 Creating Your Own Formulas
19 Adding and Editing Formulas Using the Formula Editor
20 Adding and Editing Formulas Using the Formula Bar
21 Adding Functions to Formulas
23 Handling Errors and Warnings in Formulas
24 Removing Formulas
24 Referring to Cells in Formulas
26
Using the Keyboard and Mouse to Create and Edit Formulas
27 Distinguishing Absolute and Relative Cell References
28 Using Operators in Formulas
28
The Arithmetic Operators
29 The Comparison Operators
30 The String Operator and the Wildcards
30 Copying or Moving Formulas and Their Computed Values
31
Viewing All Formulas in a Spreadsheet
32 Finding and Replacing Formula Elements
33 Chapter 2: Overview of the iWork Functions
33 An Introduction to Functions
34
Information About Functions
34 Syntax Elements and Terms Used In Function Definitions
36 Value Types
40 Listing of Function Categories
41 Pasting from Examples in Help
42
Chapter 3: Date and Time Functions
42 Listing of Date and Time Functions
44 DATE
3
Contents