| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can't get two variable tables to work
I can't understand the excel help in 2003 or in 2007 on setting up a 2
variable input table. Can anyone help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
Try this illustrative sample from my archives:
http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
Thanks Max, looks like it is just what I need. Lisa
"Max" wrote: Try this illustrative sample from my archives: http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
welcome, Lisa.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "clicktraining" wrote in message ... Thanks Max, looks like it is just what I need. Lisa |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
welcome, Lisa.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "clicktraining" wrote in message ... Thanks Max, looks like it is just what I need. Lisa |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
Thanks Max, looks like it is just what I need. Lisa
"Max" wrote: Try this illustrative sample from my archives: http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
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 "Max" wrote: Try this illustrative sample from my archives: http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
"floram" wrote:
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. Here's a sample to illustrate: http://savefile.com/files/1007074 One variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
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? |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't get two variable tables to work
Try this illustrative sample from my archives:
http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limitations to 2 variable data tables? | Excel Worksheet Functions | |||
| Dynamic scenarios - more than 2 variable using data tables in Exc | Excel Discussion (Misc queries) | |||
| Difference between 2 dates, incl weekends, with variable work days | Excel Discussion (Misc queries) | |||
| Difference between 2 dates, incl weekends, with variable work days | Excel Worksheet Functions | |||
| work roster with variable inputs | Excel Discussion (Misc queries) | |||
Hybrid Mode
