Calc Guide

Steps 2: Setting the exchange rate of Eur at 7.5, then copying it to E3
Copying formula from E2 to E3 & changing the formula to read absolute reference
Applying the correct formula from E2 to E3
Figure 132: Absolute References
The $ signs before the D and the 1 convert the reference to cell D1
from relative to absolute or fixed. If the formula is copied to another
cell the second part will always show $D$1. The interpretation of this
formula is “take the value in the cell one column to the left in the same
row and multiply it by the value in cell D1”.
Cell references can be shown in four ways:
Reference Explanation
D1 Relative, from cell E3: the cell one column to the left
and two rows above
$D$1 Absolute, from cell E3: the cell D1
$D1 Partially absolute, from cell E3: the cell in column D
and two rows above
D$1 Partially absolute, from cell E3: the cell one column to
the left and row 1
Chapter 7 Using Formulas and Functions 191