# Libreoffice Examples

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

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

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

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