-
On the Data tab, select
-
Choose one of the following tools:
-
Scenario Manager to create and save different groups of values.
-
Goal Seek to find the input values needed to achieve a specific result.
-
Data Table to see the effects of one or two variables on a formula.
-
Tip:Â For more advanced models, you can use the Solver add-in. Learn more about these tools in the Introduction to What-If Analysis.
AI-generated content might be incorrect. To learn more, see AI-generated Answers: FAQ.
-
On the Data tab, select
-
Choose one of the following tools:
-
Scenario Manager to create and save different groups of values and switch between them.
-
Goal Seek to find the input values needed to achieve a desired result.
-
Data Table to see the effects of one or two variables on a formula.
-
Tip:Â For more advanced models, you can use the Solver add-in. For more information, see Introduction to What-If Analysis.
AI-generated content might be incorrect. To learn more, see AI-generated Answers: FAQ.
-
Select the range of cells you want to use for your data table and enter the formula you want to test in the top-left cell.
-
Enter the variable values in the first row or column of the data table and select the range of cells that includes the formula and the variable values.
-
On the Data tab, select What-If Analysis > Data Table. Enter the cell references for the row and column input cells, then select OK.
Tip:Â Use one-variable tests to see how different values of one variable change the results, and two-variable tests to see how different values of two variables change the results. For more detailed information, see Overview of What-If Analysis.
AI-generated content might be incorrect. To learn more, see AI-generated Answers: FAQ.
