Apple Pages User's Guide download pdf (Page 200)

200 Chapter 9 Using Formulas and Functions in Tables

Using Functions

A function is a predefined, named operation (such as SUM and AVERAGE) that you can

use to perform a calculation in a table cell.

There are several families of functions, ranging from financial functions that calculate

interest rates, investment values, and more to statistical functions that calculate

averages, probabilities, standard deviations, and more. See Pages Help for complete

information about all the functions, including the arguments you specify to provide the

data for functions to use in their calculations.

Although you can type a function into the text field of the Formula Editor, using the

Function Browser is the quickest way to add a function to a formula.

To use the Function Browser to add a function:

1 Select the cell in which you want to add a function.

2 Choose Insert > Function > More Functions. The Function Browser opens.

3 Select a function.

To find a function, scroll through the list on the right, optionally subdividing the list by

selecting a function category on the left. You can also search for a specific function

within the selected function category by using the search field in the upper right.

4 Click Insert. The Formula Editor is displayed in the cell.

Pages inserts the function into the text field, followed by one or more argument

placeholders, within parentheses.

5 Use the Formula Editor to replace each placeholder with a cell reference or other value

or perform any additional formula editing required.

1 ... 199 200 201 ... 246

No comments

Apple Pages User's Guide Page 200