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.