Functions by Category
This section describes the functions of Office Calc. The various functions are divided into categories in the Function Wizard.
Database
The twelve functions in the Database category help you to analyse a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.
Date & Time
These spreadsheet functions are used for inserting and editing dates and times.
Financial
This category contains the mathematical finance functions of Office Calc.
Information
This category contains the Information functions.
Logical
This category contains the Logical functions.
Mathematical
This category contains the Mathematical functions for Calc.
Array
This category contains the array functions.
Statistical
This category contains the Statistics functions.
Spreadsheet
This section contains descriptions of the Spreadsheet functions together with an example.
Text
This section contains descriptions of the Text functions.
Add-in
The following describes and lists some of the available add-in functions.