The following step by step example covers how to create and use a basic formula in OpenOffice Calc.
Entering the Data
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
Select thecellC1and enter3, then pressEnter.
pick the cellC2and enter2, then pressEnter.
This is where we’ll enter the basic addition formula.
When creating formulas in Open Office Calc, youalwaysstart by typing the equals sign.
key in it in the cell where you want the answer to appear.
The best way of adding cell references is by using the mouse to go for the correct cell.
For basic addition, enter the+after theC1.
Now add the second cell to the formula.
snag the cellC2 to add the second number.
PressEnterto complete the formula.
Mathematical Operators in OpenOffice Calc Formulas
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.
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:
B.E.D.M.A.S.
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.
