Microsoft Office Tutorials and References
In Depth Information
Working with Tables
This workbook, named table formulas.xlsx , is available on the companion
CD-ROM.
1. Activate cell E2 and type Difference for the column header.
Excel automatically expands the table to include a new column.
2. Move to cell E3 and type an equal sign to signify the beginning of a formula.
3. Press , and Excel displays =[@Actual], which is the column heading in the Formula bar.
4. Type a minus sign and then press twice. Excel displays =[@Actual]–[@Projected] in
your formula.
5. Press Enter to end the formula.
Excel copies the formula to all rows in the table.
Figure 9-12 shows the table with the new column.
Figure 9-12: The Difference column contains a formula.
If you examine the table, you’ll find this formula for all cells in the Difference column:
=[@Actual]–[@Projected]
The “at” symbol (@) that precedes the column header represents “this row” (the row
that contains the formula).
Keep in mind that I didn’t define any names in this worksheet. The formula uses table references
that are based on the column names. If you change the text in a column header, any formulas
that refer to that data update automatically.
 
Search JabSto ::




Custom Search