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.