Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Formulas and Functions for Crunching Numbers
Referring to formula results in formulas
Besides referring to cells with numbers in them, you can refer to formula
results in a cell. Consider the worksheet shown in Figure 3-4. The purpose of
this worksheet is to track scoring by the players on a basketball team over
✦ The Totals column (column E) shows the total points each player scored
in the three games.
✦ The Average column (column F), using the formula results in the Totals
column, determines how much each player has scored on average. The
Average column does that by dividing the results in column E by 3, the
number of games played.
In this case, Excel uses the results of the total-calculation formulas in
column E to compute average points per game in column F.