Libreoffice Examples

Posted onby admin

All formulas begin with an equals sign. The formulas can contain numbers, text, arithmetic operators, logic operators, or functions.

  1. Libreoffice Sample Database
  2. Libreoffice Database Examples

Libreoffice Sample Database

Subforums: MS Windows, Linux, Mac OSX, LibreOffice 18192 Topics 93731 Posts Last post Re: Multiple Vulnerabilit by JohnHa Thu May 06, 2021 11:40 pm; Tutorials Home made tutorials, by users, for users Subforums: Writer, Calc, Base, Database Examples 174 Topics 688 Posts Last post Family Tree by chrisb Tue Apr 20, 2021 3:25 am. Create a form for our employee table to view each employee individually, and how to quickly find a record you are looking for.

Libreoffice Database Examples

Remember that the basic arithmetic operators (+, -, *, /) can be used in formulas using the 'Multiplication and Division before Addition and Subtraction' rule. Instead of writing =SUM(A1:B1) you can write =A1+B1.

Libreoffice database download

Parentheses can also be used. The result of the formula =(1+2)*3 produces a different result than =1+2*3.

Libreoffice

Here are a few examples of LibreOffice Calc formulas:

=A1+10

Displays the contents of cell A1 plus 10.

=A1*16%

Displays 16% of the contents of A1.

=A1 * A2

Displays 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.


It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.

Related Topics