OpenOffice Calc Formulas Tutorial

OpenOffice Calc, the spreadsheet program offered free of charge by openoffice.org, allows you to perform calculations on data entered into the spreadsheet.

You can use OpenOffice Calc formulas for basic number crunching, such as addition or subtraction, as well as more complex calculations such as payroll deductions or averaging a student's test results.

In addition, if you change the data Calc will automatically recalculate the answer without you having to re-enter the formula.

The following step by step example covers how to create and use a basic formula in OpenOffice Calc.

01
of 05

OpenOffice Calc Formula Tutorial: Step 1of 3

OpenOffice Calc Formula Tutorial
OpenOffice Calc Formula Tutorial. © Ted French

The following example creates a basic formula. The steps used to create this formula are the same ones to follow when writing more complex formulas. The formula will add the numbers 3 + 2. The final formula will look like this:

= C1 + C2

 

Step 1: Entering the data

Note: For help with this tutorial refer to the image above.

  1. Type a 3 in cell C1 and press the ENTER key on the keyboard.
     
  2. Type a 2 in cell C2 and press the ENTER key on the keyboard.
02
of 05

OpenOffice Calc Formula Tutorial: Step 2 of 3

OpenOffice Calc Formula Tutorial
OpenOffice Calc Formula Tutorial. © Ted French

When creating formulas in Open Office Calc, you ALWAYS start by typing the equal sign. You type it in the cell where you want the answer to appear.

Note: For help with this example refer to the image above.

  1. Click on cell C3 (outlined in black in the image) with your mouse pointer.
     
  2. Type the equal sign ( = ) in cell C3.
03
of 05

OpenOffice Calc Formula Tutorial: Step 3 of 3

OpenOffice Calc Formula Tutorial
OpenOffice Calc Formula Tutorial. © Ted French

Following the equal sign, we add in the cell references of the cells containing our data.

By using the cell references of our data in the formula, the formula will automatically update the answer if the data in cells C1 and C2 changes.

The best way of adding cell references is by using the mouse to point and click on the correct cell. This method allows you to click with your mouse on the cell containing your data to add its cell reference to the formula.

After the equal sign added in step 2

  1. Click on cell C1 with the mouse pointer.
     
  2. Type a plus ( + ) sign.
     
  3. Click on cell C2 with the mouse pointer.
     
  4. Press the ENTER key on the keyboard.
     
  5. The answer 5 should appear in cell C3.
     
  6. Click on cell C3. The formula is shown in the input line above the worksheet.
04
of 05

Mathematical Operators in OpenOffice Calc Formulas

The mathematical operator keys on the number pad are used to create Calc Formulas.
The mathematical operator keys on the number pad are used to create Calc Formulas. © Ted French

Creating formulas in OpenOffice Calc is not difficult. Just combine the cell references of your data with the correct mathematical operator.

The mathematical operators used in Calc formulas are similar to the ones used in math class.

  • Subtraction - minus sign ( - )
  • Addition - plus sign ( + )
  • Division - forward slash ( / )
  • Multiplication - asterisk (* )
  • Exponentiation - caret (^ )
05
of 05

OpenOffice Calc Order of Operations

OpenOffice Calc Formula Tutorial
OpenOffice Calc Formula Tutorial. © Ted French Ted French

If more than one operator is used in a formula, there is a specific order that Calc will follow to perform these mathematical operations. This order of operations can be changed by adding brackets to the equation. An easy way to remember the order of operations is to use the acronym:

BEDMAS

The Order of Operations is:

  • Brackets
    Exponents
    Division
    Multiplication
    Addition
    Subtraction

How the Order of Operations Works

Any operation(s) contained in brackets will be carried out first followed by any exponents.

After that, Calc considers division or multiplication operations to be of equal importance, and carries out these operations in the order they occur left to right in the equation.

The same goes for the next two operations � addition and subtraction. They are considered equal in the order of operations. Whichever one appears first in an equation, either addition or subtraction, is the operation carried out first.

Format
mla apa chicago
Your Citation
French, Ted. "OpenOffice Calc Formulas Tutorial." ThoughtCo, Jan. 15, 2018, thoughtco.com/openoffice-calc-formulas-tutorial-3123953. French, Ted. (2018, January 15). OpenOffice Calc Formulas Tutorial. Retrieved from https://www.thoughtco.com/openoffice-calc-formulas-tutorial-3123953 French, Ted. "OpenOffice Calc Formulas Tutorial." ThoughtCo. https://www.thoughtco.com/openoffice-calc-formulas-tutorial-3123953 (accessed January 17, 2018).