How do I build a sensitivity analysis table?
 

I want to have a table where in one row there is one variable while on the
left column there is another variable. Inside the table there are the values
which depend on the two variables, including a fix value which is outside
that table. i am looking at excel spreasheet like that and it seems that if I
stand on any of the cells in side the table the function is
{=TABLE(cell,cell)} what are the "}" for?
I can't find information about a "TABLE" function...
Thanks for your help...

How do I build a sensitivity analysis table?
 

OS -

The feature is called a Data Table. The function is entered via the Table
item on the Data menu (pre-2007 Excel). For more info, search Excel Help for
"data tables" or "about data tables."

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"OS" wrote in message
...
I want to have a table where in one row there is one variable while on the
left column there is another variable. Inside the table there are the
values
which depend on the two variables, including a fix value which is outside
that table. i am looking at excel spreasheet like that and it seems that
if I
stand on any of the cells in side the table the function is
{=TABLE(cell,cell)} what are the "}" for?
I can't find information about a "TABLE" function...
Thanks for your help...