can't get two variable tables to work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't understand the excel help in 2003 or in 2007 on setting up a 2
variable input table. Can anyone help?
 
Not sure what you mean by a two variable input table so could you explain
with an example?
 
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
 
Can you please provide a sample of just one variable. The sample that is
provided in the help section just talks about calculating interest rates. I
need something a bit more simple. All I really want to do is calculate a 3%,
4%, 5%, 6% increase of a total budget.

Can you help.

Thanks,

Flora
 
floram said:
Can you please provide a sample of just one variable. The sample that is
provided in the help section just talks about calculating interest rates. I
need something a bit more simple. All I really want to do is calculate a 3%,
4%, 5%, 6% increase of a total budget.
Click to expand...

Here's a sample to illustrate:
http://savefile.com/files/1007074
One variable data table example.xls

---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a single value from tables by selecting two variable inputs? 8
How to create a bubble chart with more than 2 variables 0
User Defined Function Help 3
Limitations to 2 variable data tables? 2
How do I build a sensitivity analysis table? 1
#n/a in table data table output 2
Two-variable Data Table - Problem with result/output 1
need a formula 7

Back
Top