Forum Discussion
Solved
Multiple Values in Scenario Manager
Hi! Is there a way to put multiple values in a changing cell using scenario manager. I want to try different values in a couple of changing cells. I think that I can't use data table because the cell...
- I'm thinking you could utilise the 2nd approach I put in the original attached file. Where the DataTable is just used to trigger scenarios. You would have to layout those scenarios in a few columns.
I am trying to apply your tables paper to a workbook which has multiple tabs and the 2 variables I am changing are set in different tabs. I am trying to change the interest rate and the number of months the loan amortizes to determine how much the total principal and interest would be over 5 and 10 years. Each of the variables are in a different tab (they are highlighted in yellow). I am not clear how to set up the table to change these variables and have the sums calculating in a third tab (DS comparison tab). Can you guide me in the right direction?
Check if the additional page in the attached file helps
P.S. best to start a new thread rather than tagging on to a solved one 🙂