Page 44 - TP_Plus_v4_Class6
P. 44
Absolute References
If you wish to maintain the original references as they were, then you should make use of the absolute
references. If you want to make the formula retain the original reference when it is copied and lock a
reference in the formula, then you should precede the column reference and the row reference by a
Dollar ($) symbol.
Example of Absolute Reference
Let's have a look at an example helping the Pokemon trainers to calculate prices for Pokeballs. Copy
the following data:
To calculate the prices for the Pokeballs.
The price's reference is B11, we do not want the fill function to change this, so we lock it.
The reference is absolutely locked by using the formula $B$11.
42 Plus (Ver. 4.0)-VI

