Page 22 - iPro_trackGPT_V5_Class8
P. 22
When you copy the formula to another cell, the reference to cell B9 will stay constant and would
not change, as illustrated:
Tech Tweak
Pressing the F4 key repeatedly over a cell reference in a formula allows you to cycle through
different types of cell references.
Mixed References
A mixed reference is a combination of relative and absolute references. It lets you lock either a
row or a column while keeping the other part adjustable. To make a mixed reference, use the
Dollar ($) symbol to fix either the row or the column.
20 TrackGPT iPRO (V5.0)-VIII

