Working with functions – Apple AppleWorks 5 : Mac OS User Manual
Page 172

7-26
AppleWorks 5 User’s Manual
2. Click cell B3, type an equal sign (=) in the entry bar, and then click cells A1,
A2, and C1.
AppleWorks inserts the addition operator (+) between each cell reference.
Your spreadsheet should look like this:
To change the formula, for example to use a different operator, use the
text editing techniques described in “Editing data” on page 7-6.
3. Click to confirm the entry.
AppleWorks adds the numbers and displays the result (950) in
cell B3. If the result doesn’t appear as you expect, check to be sure that
you started the formula with an equal sign (=).
Working with functions
AppleWorks provides functions, or built-in routines, that you can use alone
or include in a formula. Use functions to perform computations—such as
summing a group of numbers or deriving a square root—without having to
type the entire formula. You can use a function by itself in a formula, or you
can combine it with other values, operators, cell references, and functions.
For an example of a simple function, see “Example: Using the AVERAGE
function” on page 7-28.
*
Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
Entry bar
Formula
Operators
The formula’s result goes
in the selected cell
Address of the
selected cell
In the Help index,
*
see:
E
functions