Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OS OS is offline
external usenet poster
 
Posts: 4
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 762
Default 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...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sensitivity analysis Alex Chung New Users to Excel 2 June 26th 12 08:15 PM
How to build effective IF Statement for recurring value in cells....sensitivity analysis [email protected] Excel Discussion (Misc queries) 1 March 30th 07 09:14 PM
Sensitivity analysis PaulHelyer Excel Worksheet Functions 1 March 2nd 06 11:00 PM


All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"