Apple iWork '08 - Manual (Page 87)

Chapter 2 Getting Started with Numbers 87
If you find a particular calculation very useful and you want to incorporate it into a
table, drag the calculation to an empty table cell anywhere in your spreadsheet.
Using Your Results in the Loan Comparison Table
Now you can use the predefined template table to compare three loans for $40,500.
To compare loans:
1 Select the Loan Comparison table.
If you were using this table for your own loan comparison, you’d change the values
for Annual Percentage Rate or loan duration (Length in Months or Length in Years) to
match the terms of the loans you’re comparing. For this exercise, we’ll use the
predefined values.
2 Select cell B2 and type the equal sign (=) to open the Formula Editor.
3 Click the lower-right cell in My Table to indicate you want to display the grand total in
cell B2 of the Loan Comparison table.
4 Click the Accept button in the Formula Editor.
The Loan Comparison table reappears, with the value $40,500 in cell B2.
5 Repeat steps 2 through 4 to add the grand total to cells C2 and D2.
Compare monthly payments …
… and compare the total costs.