Calculating in Spreadsheets

From LibreOffice Help
Jump to: navigation, search

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

  1. Click in a cell, and type a number
  2. Press 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 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.

Related Topics

Calculating With Dates and Times

Automatically Filling in Data Based on Adjacent Cells

Calculating Time Differences

Referencing Other Sheets