Get instant live expert help on I need help with sensitivity table excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need to create a sensitivity table should on the x axis time and on the y access the different values pulled from another data table in the same excel spread sheet. I need to be able to flex the y axis (by building in a multiple) and then obviously this has to change the values inside the sensitivity table itself.
Solved by D. D. in 29 mins
My data table sensitivity analysis isn't working. I get the same results for each cell. The calculation is set to automatic. The rows and columns are correct. The formula being referenced is on the same sheet. Please see tab "H. Sensitivity Analysis."
You'll see 5703316771 is the value for each cell in the two-variable scenario.
Solved by X. C. in 23 mins
I need help understanding the Limits and Sensitivity Reports (tabs: 'FS A-B Limits Report' and 'FS A-B Sensitivity Report')
Solved by X. H. in 19 mins
The answer report is not showing up. Only sensitivity reports.
Solved by O. L. in 13 mins
i dont know how they arrived at the figures on excel foe sensitivity analysis, level of inflation and scenario analysis.
Solved by A. C. in 15 mins