Microsoft Excel has functions to perform the analysis. In general, sensitivity analysis is calculated using formulas with different input cells. For example, a company may perform NPV analysis ...

This function tells Excel, "If the previous result ... Then, we will create a sensitivity analysis table by using the feature data or Table Data table (this sensitivity will be inserted in ...