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
   39   40   41   42   43   44   45   46   47   48   49