When you copy a formula, Excel shifts its references. =B2*C1 copied one row down becomes =B3*C2. This is a relative reference.
If a reference must always point to the same cell (a tax rate, an exchange rate), lock it with $:
A1 | relative — both column and row change |
$A$1 | absolute — nothing changes |
A$1 | mixed — the row is locked |
$A1 | mixed — the column is locked |
In Excel the F4 key cycles through these four options for the reference under the cursor.
Tip from the manual (Develop Effective and Efficient Solutions): put all assumptions (rates, factors) in separate cells and reference them absolutely instead of hard-coding numbers into formulas.