Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

How do I build a sensitivity analysis table?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
OS - 12 Sep 2007 20:46 GMT
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...
Mike Middleton - 12 Sep 2007 20:55 GMT
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

>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
[quoted text clipped - 6 lines]
> I can't find information about a "TABLE" function...
> Thanks for your help...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.