What if analysis 2007

Because you focus on only one or two variables, results are easy to read and share in tabular form. If automatic recalculation is enabled for the workbook, the data in Data Tables immediately recalculates; as a result, you always have fresh data.

Cell B3 contains the input value. A Data Table cannot accommodate more than two variables. If you want to analyze more than two variables, you can use Scenarios.

Although it is limited to only one or two variables, a Data Table can use as many different variable values as you want. A Scenario can have a maximum of 32 different values, but you can create as many scenarios as you want. If you want to prepare forecasts, you can use Excel to automatically generate future values that are based on existing data, or to automatically generate extrapolated values that are based on linear trend or growth trend calculations. You can fill in a series of values that fit a simple linear trend or an exponential growth trend by using the fill handle or the Series command.

To extend complex and nonlinear data, you can use worksheet functions or the regression analysis tool in the Analysis ToolPak Add-in. Although Goal Seek can accommodate only one variable, you can project backward for more variables by using the Solver add-in. By using Solver, you can find an optimal value for a formula in one cell—called the target cell—on a worksheet. Solver works with a group of cells that are related to the formula in the target cell.

Solver adjusts the values in the changing cells that you specify—called the adjustable cells—to produce the result that you specify from the target cell formula. You can apply constraints to restrict the values that Solver can use in the model, and the constraints can refer to other cells that affect the target cell formula.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Goal Seek. Data Tables. Using Solver for capital budgeting.

Using Solver to determine the optimal product mix. Define and solve a problem by using Solver. Analysis ToolPak Add-in. Overview of formulas in Excel. How to avoid broken formulas. Detect errors in formulas. Keyboard shortcuts in Excel. Excel functions alphabetical. Excel functions by category. Changing cells 2. Result cell 1.

The formula that appears in cell B5 in the example image is a function. It isn't part of the what-if analysis tool, so you will need to understand functions thoroughly before you use what-if analysis. For the example scenario described above, you need a formula that will calculate the monthly payment.

Instead of writing the formula yourself, you can insert a function to do the calculation for you. There are three What-If analysis tools that you can use. What-If Analysis in Excel allows you to try out different values scenarios for formulas. The following example helps you master what-if analysis quickly and easily.

Assume you own a book store and have books in storage. Each different percentage is a different scenario. You can use the Scenario Manager to create these scenarios. Note: You can simply type in a different percentage into cell C4 to see the corresponding result of a scenario in cell D