Microsoft Office Tutorials and References

In Depth Information

This workbook, named table formulas.xlsx, is available at this book's website.

Figure 9-12:
Adding a calculated column to this table is easy.

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-13 shows the table with the new calculated column.