| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I create what if analysis in excel 2000?
Hi,
how do I find the what if analysis function in ver. excel 2000? Regards Tony |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I create what if analysis in excel 2000?
I have never used Excel 2000 but other versions have a goalseek function.
Check it out in help. Or possibly load the solver add-in which was available in 2000 Gord Dibben MS Excel MVP On Sun, 6 Sep 2009 06:35:01 -0700, Tony wrote: Hi, how do I find the what if analysis function in ver. excel 2000? Regards Tony |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I create what if analysis in excel 2000?
Tony -
In Excel 2007, the Data ribbon has a Data Tools section with a "What-If Analysis" drop-down containing Scenario Manager, Goal Seek, and Data Table. In Excel 2000 SP3, the Tools menu has the Scenario and Goal Seek items, and the Data menu has the Table item. Self-Promotion: My sensitivity analysis add-in, SensIt, available from www.treeplan.com, is also useful for what if analysis. - Mike http://www.MikeMiddleton.com "Tony" wrote in message ... Hi, how do I find the what if analysis function in ver. excel 2000? Regards Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Analysis Toolpak Excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2007 & Analysis Services 2000 | Excel Discussion (Misc queries) | |||
| Date analysis key in Excel 2000 | New Users to Excel | |||
| How do I install Excel 2000 Analysis Tool Pak? | Excel Discussion (Misc queries) | |||
| How do I install Excel 2000 Analysis Tool Pak? | Excel Discussion (Misc queries) | |||
Hybrid Mode
