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

 


Table of contents | Index