I have the following table which I have to fill in using a 2 variable data
table and I don't know how:

Loan Interest Term Monthly Repayment
50000 10% 25 £2,223.85 (PMT formula)

9.0% 9.5% 10.0% 10.5% 11.0% 11.5%
20000
30000
40000
50000
60000
70000
80000



"Toppers" wrote:

Not sure what you mean by a two variable input table so could you explain
with an example?

"clicktraining" wrote:

I can't understand the excel help in 2003 or in 2007 on setting up a 2
variable input table. Can anyone help?