OpenOffice Calc: relation to cell

You'll learn in this practical tip on how you can put in OpenOffice Calc, a reference to a specific cell.

So you put in Calc, a reference to a specific cell

Under OpenOffice Calc you can easily reference to a specific cell.

With the formula "=SUM(range)" you can have the sum for a particular area to be calculated.
If you, for example, the range [A10] want to [A20], as a sum, the formula is "=SUM(A10:A20)". As soon as you move the values, however, the formula is useless.
With a Dollar sign written before the specific cell, set an absolute reference to the cell, in our example, [A10] (see Screenshot).
The formula is "=SUM($A10:A20)". The result then relates directly to the cell [A10].

You want to calculate for a column, a surcharge or Similar, you can fix it with the [$] character.

In a free cell the context of the amount.
You want to add like in the above example, the values in the cells [A10] to [A20], and the results in column [B] to identify, type the formula "=A10+$(cell charge)".
This formula allows you to fill in the entire column down. To each value in column [A] is then calculated the premium to do so.
Of course, this works also for all the other arithmetic operators.

This practical tip is based on OpenOffice Calc 4.0.1 in Windows 7. You can also under OpenOffice Calc, the cells to concatenate.