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

