There's many ways to do this, but the easiest one is probably the way I've done it in attached workbook.
Hi all, I have a table as identified below which I would like to automatically populate depending on whether I chose the base, the optimistic, or the pessimistic assumption in my Excel sheet. I currently have to populate this table manually because I only have one output cell for income.
What would be the best way to have Excel 'remember' the value of the 'base' income if I chose the optimistic scenario, and likewise have Excel remember the value of the Optimistic income if I chose Pessimistic? Should I be using VBA? Can you please give me a few pointers on what I should be looking for? Is there a way to do this with formulas?
Scenario | Base | Optimistic | Pessimistic
Total Income |$840,446 | $5,408,013 | ($3,728,664)