Select the Range E2:K8, and click Data > What-If Analysis > Data Table. (3) In the Cell E2, please type the formula =B14ģ. (2) In Range E3:E8, please type the prices from 75 to 200 (1) In Range F2:K2, please type the sales volumes from 500 to 1750 Prepare the sensitivity analysis table as below screenshot shown: (4) In Cell B14, please type the formula =B13-B6-B7.Ģ. (3) In Cell B13, please type the formula =B11-B12 (2) In Cell B12, please type the formula =B5*B3 (1) In Cell B11, Please type the formula =B4*B3 Finish the Profit & Loss Statement table as below screenshot shown:
This method will apply the Data Table feature to do a sensitivity analysis in Excel.