Functions by Category

This section describes the functions of LibreOffice Calc. The various functions are divided into categories in the Function Wizard.

Database

The twelve functions in the Database category help you to analyze 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 LibreOffice 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.

Please support us!