Owner manual
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 Predened 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 Denitions
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