Sensitivity Analyzer

An add-in for Microsoft Excel that performs "what if" analysis quickly and easily.

  • Run multiple what if cases in minutes
  • Run all possible combinations of your cases
  • Vary multiple cells in specific increments
  • Extract output values to a new worksheet

The Sensitivity Analyzer add-in for Microsoft Excel performs “what if” analysis quickly and easily, and saves you a lot of time. It is compatible with Microsoft Excel 2010-2021 and Office 365.

The Sensitivity Analyzer add-in allows you to vary the data in up to five cells and return the values of up to ten other cells. You can specify the starting, stopping, and step values for each of the five cells. It does the calculations and data processing far faster than you can manually, saving you time and eliminating the pain of doing many cases manually. And it puts the original data back in the worksheet cells when it is done processing the cases!

It automatically creates a report containing the information on all the cases. The following illustrates just such a report, where price and cost per unit has been varied to see the effect on profit, margin and return on investment:

Sensitivity Analyzer results report
Example sensitivity report

Customers who viewed this also viewed