About functions

A function is a predefined, named formula you can use to perform a calculation in either a spreadsheet cell or a calculation or summary database field.

AppleWorks supports more than 100 predefined functions. Functions consist of the function name followed by one or more arguments enclosed in parentheses. Arguments are the values you supply to a function so that it can perform a calculation. For example, the following formula, used in a spreadsheet cell, adds the values in column A, rows 2 through 10:

=SUM(A2..A10)

Valid function arguments include
a constant value
the result of an expression or calculation, including a logical (Boolean) value or expression
a spreadsheet cell or a text, number, date, or time database field
another function

Related topics

  Using formulas and functions in a spreadsheet
Entering a formula in a database field

 
Table of contents Index