Storing values from one output cell

chaneld

New member
Joined
Jun 10, 2011
Messages
2
Reaction score
0
Points
0
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)


Thanks
Chanel
 
Top