How do I build a sensitivity analysis table?

G

Guest

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...
 
M

Mike Middleton

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
 

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

Produce a financial sensitivity analysis graph in Excel 2007 1
return value from table 2
What does this function do? {=table(D19,D21)} 6
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Sensitivity analysis 1
How do I have a data table display cell names rather than values? 1
Case Sensitivity in Lookup Functions 4
zero value in cell 2

Top