Page 43 - TP_Plus_v4_Class6
P. 43

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