Owner's manual

Spreadsheet 7-27
AppleWorks provides over 100 functions in nine general categories. A
complete list of these functions is in onscreen Help.
Entering functions
To enter a function:
1. Click the cell where you want the result to appear.
If you’re including the function as part of a larger formula, click in the
formula where you want the function to appear.
2. Choose Paste Function from the Edit menu (or click on the entry bar).
3. Choose the type of function you want from the Category pop-up menu in the
Paste Function dialog box, select a function from the alphabetical list, and then
click OK.
4. In the entry bar, select the sample values and replace them with values, named
cells, or cell references.
For more information, see “Naming cells and ranges” on page 7-12, and
“Cell references in formulas” on page 7-22.
5. When you’re satisfied with your entry, click to confirm it.
Category Purpose Example
Business and
Financial
Calculates mortgage and payment values PMT (Payment)
Date and Time Manipulates dates and times DATE
Information Looks up and evaluates information in
spreadsheet cells, cell ranges, and database fields
LOOKUP
Logical Evaluates Boolean expressions, which result in
either TRUE or FALSE
ISBLANK
Numeric Performs general mathematical calculations ROUND
Statistical Calculates general statistics, such as standard
deviation and variance
AVERAGE
Text Finds, compares, and manipulates text
expressions
CODE (ASCII code)
Trigonometric Creates and evaluates mathematical and
scientific values
SIN
*
Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,* see:
E functions