Manual

Spreadsheet's Built.in Functions
Spreadsheet provides the following built-in function types:
• Financial
• Information
• Logical
• Math
• Print
• Statistical
• String
• Time and Date
• Trigonometric
When you select Insert Function from the Formula menu, a dialog box
appears with a list of these function types on the left and the built-in
functions on the fight. For example, when you select MATH from the left, the
corresponding math functions appear on the fight. If you select ALL from the
left, all of Spreadsheet's functions appear on the fight in alphabetical order.
This section gives general descriptions of the function types. More detailed
information is in the Appendix, beginning on page 215.
Financial functions
Financial functions provide formulas for common financial calculations. For
example, the FV (Future Value) function calculates the future value of a
stream of regularly invested payments.
The arguments for financial functions are either values or addresses of cells
that contain values. When the argument is the interest rate, express it as its
actual value (.07 rather than 7 to indicate 7%). Be sure to specify the same
units for the term and the interest. If the interest is monthly, the term is also
monthly.
Information functions
The information functions return information about a cell or range of cells.
For example, the COUNT function counts the number of items in a list.
Spreadsheet 91