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

three games:

✦
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.

Figure 3-4:

Using

formula

results

as other

formulas.