Loading…
Loading…
When you copy a formula, relative references (A1) shift with it. Absolute references ($A$1) stay locked. Mixed references lock only the column ($A1) or only the row (A$1). While editing a formula, press F4 (Mac: ⌘+T) to cycle through the four types.
Syntax
=B2*(1+$F$1)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.