Sensitivity Anallysis

[Mitch222]

I have an issues that maybe very basic to solve
1) I’m running a two variable sensitivity analysis and for some reason I can’t get the results needed. I’ve entered both variables one in the column and the other in the row but the data analysis does not calculate any changes..

Can someone explain what is wrong with my data analysis/model

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Mitch222]

Take a look

[JeteMc]

Hello Mitch and Welcome to Excel Forum.
I believe that the reason the data table is returning static results is that the value of D2 is static as opposed to a value based on a formula. As you can see in this video from Highline College cell G9 needs to reference a cell that has a formula.
Let us know if you have any questions.

[Mitch222]

Thanks for your help....I've included the formula but I still getting the static results..

[JeteMc]

The formula needs to show the relationship between E10 and the values in E16 and E17 as they are the cells used for column and row input.
Let us know if you have any questions.

[JeteMc]

The way the formula reads at the moment E5 and E7 could be used as the row and column inputs (as shown in the attached file).