Results 1 to 3 of 3

Thread: Storing values from one output cell

  1. #1

    Storing values from one output cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    356
    Articles
    0
    There's many ways to do this, but the easiest one is probably the way I've done it in attached workbook.

    See http://www.contextures.com/xlDataVal02.html
    Attached Files Attached Files

  3. #3
    Quote Originally Posted by JeffreyWeir View Post
    There's many ways to do this, but the easiest one is probably the way I've done it in attached workbook.

    See http://www.contextures.com/xlDataVal02.html

    thank you very much for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •