+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : "What if calculations" returning same number

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    "What if calculations" returning same number

    I'm perfroming a sensitivity analysis, however when I run the what if calcuation my outputs are the same. For example, below is an example of what I've tried to run and how I went about it:

    2,000 1 2 3 4 variables: 10%, 2
    5%
    10%
    15%
    20%

    I highlighted the chart above (correctly) and input the variables in their respective rows and columns. The fields, as mentioned above, returs 2,000 in all of the output cells. I do not understand why this is not working out. Any thoughts?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: "What if calculations" returning same number

    People would be hard pressed to guess without seeing the workbook.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Re: "What if calculations" returning same number

    Quote Originally Posted by shg View Post
    People would be hard pressed to guess without seeing the workbook.
    Fair enough.
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: "What if calculations" returning same number

    B6 contains nothing but a number; it should be the calculated result of a model.

  5. #5
    Forum Contributor
    Join Date
    07-01-2010
    Location
    United States, Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    116

    Re: "What if calculations" returning same number

    Figured this much and it works. Thanks!

  6. #6
    Registered User
    Join Date
    12-26-2015
    Location
    Delhi, India
    MS-Off Ver
    2010
    Posts
    1

    Re: Excel 2007 : "What if calculations" returning same number

    Hi, I am facing the same problem.
    can anybody help me?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1