what if analysis in excel

What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. There are three main types of What-If Analysis tools that come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data Tables take sets of input values and determine possible results, while Goal Seek lets you start with the desired result and calculates the input value that will give you that result. A Data Table in Excel What-If Analysis eases the challenging task of calculating fields and storing results in cells with just a simple drag and drop operation