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
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
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? |
#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
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? |
#8
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? |
#9
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? |
#10
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 |
#11
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 |
#12
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? |
#13
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 --- |
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) |