Microsoft Office Tutorials and References
In Depth Information
Figure 9-13: 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 @ symbol that precedes the column header represents “this row” (the row that
contains the formula). So each formula in column E calculates “this row's Actual value
minus this row's Projected value.”
The syntax is a bit different if a column header contains spaces or non-alphanumeric characters such as a pound
sign, an asterisk, and so on). In such a case, Excel encloses the column header text in brackets (not quote
marks). For example, if the column C header was Projected Income , the formula would appear as
=[@Actual]-[@[Projected Income]]
Some symbols in a column header (such as a square bracket) require the use of an apostrophe as an escape char-
acter. It is usually much simpler to create table formulas by pointing, and let Excel handle the syntax details.
Search JabSto ::




Custom Search