What-If Analysis is the process of changing various values in cells to check the outcome of formulas in different ways without creating different sheets. DsExcel supports Scenarios and Goal Seek Operation of What-If Analysis tools.
Scenarios take sets of input values and determine possible results based on those values. Whereas Goal Seek Operation works differently from Scenarios; it takes a result and determines possible input value that produce that result.
Refer to the following topics for more information on the What-If Analysis tools:
