Calculating in Spreadsheets

The following is an example of a calculation in LibreOffice Calc.

  1. Click in a cell, and type a number

  2. Press Ctrl+Enter.

    The cursor moves down to the next cell.

  3. Enter another number.

  4. Press the Tab key.

    The cursor moves to the right into the next cell.

  5. Type in a formula, for example, =A3 * A4 / 100.

  6. Press Ctrl+Enter.

    The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.

    When you edit a formula, the new result is calculated automatically.