Text Documents (Writer)

General Information and User Interface Usage

Command and Menu Reference

Navigating Text Documents

Formatting Text Documents

Templates and Styles

Graphics in Text Documents

Tables in Text Documents

Objects in Text Documents

Sections and Frames in Text Documents

Tables of Contents and Indexes

Fields in Text Documents

Calculating in Text Documents

Special Text Elements

Automatic Functions

Numbering and Lists

Spell Checking, Thesaurus and Languages

Troubleshooting Tips

Loading, Saving, Importing, Exporting and Redacting

Master Documents

Links and References

Printing

Searching and Replacing

HTML Documents (Writer Web)

Spreadsheets (Calc)

General Information and User Interface Usage

Command and Menu Reference

Functions Types and Operators

Loading, Saving, Importing, Exporting and Redacting

Formatting

Filtering and Sorting

Printing

Pivot Table

Pivot Chart

Scenarios

Subtotals

References

Viewing, Selecting, Copying

Formulae and Calculations

Presentations (Impress)

General Information and User Interface Usage

Command and Menu Reference

Loading, Saving, Importing, Exporting and Redacting

Formatting

Effects

Objects, Graphics and Bitmaps

Text in Presentations

Drawings (Draw)

General Information and User Interface Usage

Command and Menu Reference

Loading, Saving, Importing and Exporting

Formatting

Objects, Graphics and Bitmaps

Groups and Layers

Text in Drawings

Viewing

Database Functionality (Base)

Formulae (Math)

General Information and User Interface Usage

Charts and Diagrams

General Information

Macros and Scripting

Office BASIC

General Information and User Interface Usage

Command Reference

Guides

Python Scripts Help

General Information and User Interface Usage

Programming with Python

Script Development Tools

Office Installation

Common Help Topics

General Information

Office and Microsoft Office

Office Options

Wizards

Letter Wizard

Fax Wizard

Agenda Wizard

HTML Export Wizard

Document Converter Wizard

Configuring Office

Working with the User Interface

Digital Signatures

Printing, Faxing, Sending

Drag & Drop

Copy and Paste

Charts and Diagrams

Load, Save, Import, Export, PDF

Links and References

Document Version Tracking

Labels and Business Cards

Inserting External Data

Automatic Functions

Searching and Replacing

Guides

All formulae begin with an equals sign. The formulae may contain numbers, text, arithmetic operators, logic operators or functions. Other data is also possible, such as format details.

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

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

Here are a few examples of Office Calc formulae:

=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 formulae, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.