Excel 2010 Bible

Part II: Working with Formulas and Functions

216

Note

You can toggle the Total Row display via Table Tools ➪ Design ➪ Table Style Options ➪ Total Row. If you turn
it off, the summary options you selected will be displayed again when you turn it back on. n

Using formulas within a table ..................................................................................

In many cases, you’ll want to use formulas within a table to perform calculations that use other col-

umns. For example, in the table shown in Figure 10.11, you may want a column that shows the

difference between the Actual and Projected amounts. To add this formula:

1. Activate cell E2 and type Difference for the column header. Excel automatically
   expands the table for you to include the new column.


2. Move to cell E3 and type an equal sign to signify the beginning of a formula.


3. Press the left arrow key. Excel displays [@Actual], which is the column heading, in
   the Formula bar.


4. Type a minus sign and then press left arrow twice. Excel displays [@Projected] in
   your formula.


5. Press Enter to end the formula. Excel copies the formula to all rows in the table.

Figure 10.12 shows the table with the new column.

FIGURE 10.12

The Difference column contains a formula.

Examine the table, and you find this formula for all cells in the Difference column:

=[@Actual]-[@Projected]