![]() ![]() The Solver add-in is similar to Goal Seek, but it can accommodate more variables. In addition to these three tools, you can install add-ins that help you perform What-If Analysis, such as the Solver add-in. ![]() A scenario can have a maximum of 32 different values, but you can create as many scenarios as you want. Although it is limited to only one or two variables (one for the row input cell and one for the column input cell), a Data Table can include as many different variable values as you want. If you want to analyze more than 32 values, and the values represent only one or two variables, you can use Data Tables. Goal Seek differs from Scenarios and Data Tables in that it takes a result and projects backwards to determine possible input values that produce that result.Įach scenario can accommodate up to 32 variable values. Scenarios and Data Tables take sets of input values and project forward to determine possible results. ![]() There are three kinds of What-If Analysis tools that come with Excel: Scenarios, Data Tables and Goal Seek. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |