Question

Formulas and functions in liberoffice Calc ?

Answer 1

=A1+10Displays the contents of cell A1 plus 10.
=A1*16%Displays 16% of the contents of A1.
=A1 * A2Displays the result of the multiplication of A1 and A2.
=ROUND(A1;1)Displays the contents of cell A1 rounded to one decimal place.
=EFFECTIVE(5%;12)Calculates the effective interest for 5% annual nominal interest with 12 payments a year.
=B8-SUM(B10:B14)Calculates B8 minus the sum of the cells B10 to B14.
=SUM(B8;SUM(B10:B14))Calculates the sum of cells B10 to B14 and adds the value to B8.


Database

This section deals with functions used with data organized as one row of data for one 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.