Insert formula
You can add functions to the spreadsheet in order to perform calculations, for example.
Procedure
- Open a spreadsheet.
- Activate the Contents tab bar.
- Click in a cell.
- Click
Insert formula > Insert formula. The dialog opens. - Click the relevant formula. A description of the formula is displayed in the dialog.
- Click OK. The formula is inserted and a clickable tooltip is displayed.
- To complete the formula, click its name.
- If required, enter the necessary parameters.
- Press Enter.
You have added a formula to the spreadsheet.
Tip
It is not necessary to enter the area for which a calculation is to apply; you can select it with the mouse, for example, cells A1 to A5.