T Tony Sep 6, 2009 #1 Hi, how do I find the what if analysis function in ver. excel 2000? Regards Tony
M Mike Middleton Sep 6, 2009 #2 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 - 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
