Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Relative References

                     By default, all cell references are Relative references , and are without dollar sign ($). The relative reference
                     makes the cells reference free. It gives the full function freedom to continue the order without restrictions.

                     Let's have a look at a relative reference example, helping the Pokemon trainers to count their Pokeballs
                     (B2:B7) and Great balls (C2:C7).

                     The result in D2 = 5. Next, fill the range D2:D7

                     The references being relative allows the fill function to continue the formula for rows downwards.

                     Have a look at the formulas in D2:D7. Notice that it calculates the next row as you fill.

                                                                                   #Charts, Formulas and Functions in Excel  45

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