Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 48 - 2620_Birla Open Mind C-6
P. 48

    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.

                      46  Premium Edition-VI

| 43 44 45 46 47 48 49 50 51 52 53 |