Insert formula

You can add functions to the spreadsheet in order to perform calculations, for example.

Procedure

  1. Open a spreadsheet.
  2. Activate the Contents tab bar.
  3. Click in a cell.
  4. Click Formula Insert formula > Insert formula. The dialog opens.
  5. Click the relevant formula. A description of the formula is displayed in the dialog.
  6. Click OK. The formula is inserted and a clickable tooltip is displayed.
  7. To complete the formula, click its name.
  8. If required, enter the necessary parameters.
  9. 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.