[ LiB ] |
Occasionally when you copy a formula, you do not want one of the cell references to change. That's when you need to create an absolute reference . To indicate an absolute reference, use the dollar sign ($).
It's called an absolute reference because when you copy it, it absolutely and positively stays that cell reference and never changes. An example of a formula with an absolute reference might be =B22*$B$24. The reference to cell B24 will not change when copied .
NOTE
Compound formulas can also have absolute references.
[ LiB ] |