Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Goal seek displays 2 results! (Excel 2002)

    HI,

    I had a user mention that when they ran Goal Seek a while back, it gave two results in the Goal Seek Status Dialog. They said that there was a button called "next", and the result showed i value initially, and when they clicked next, it showed the other result. I asked if they were sure if it was Goal Seek and not Solver...and they said definitely Goal Seek. Anyone seen this before???

    Also, what are the other two buttons for? Step and Pause! I've never seen them active in the reults dialog!!

    TIA
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Goal seek displays 2 results! (Excel 2002)

    I haven't ever seen a Next button in the Goal Seek dialog.

    Step and Pause can be used for slowly or badly converging goal seek problems, where finding a solution takes a long time. You can pause the iteration temporarily, then continue it step by step to see what is happening.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Goal seek displays 2 results! (Excel 2002)

    I also haven't seen a Next button...that why I was so surprized at what this user mentioned. I thought I'd run a confirmation post on the nets best site! (I guess the lack of replies also says what I expected!) <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thx for the explaning of the other 2 buttons. It's stange to see this as goal seek only runs one variable. I figure that is really rare that it will have to calculate thousands of iterations!!
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Goal seek displays 2 results! (Excel 2002)

    It very much depends on the kind of functions used, and on the precision required by the user. By default, Excel will stop after 100 iterations or when the values involved change by less than 0.001, whichever occurs first. But you can change these limits in the Iteration section of the Calculation tab of Tools | Options...
    specifying more steps (with a maximum of 32,767) and/or a smaller change will cause Goal Seek to take longer, and in some situations it may be impossible to find a solution with the desired precision. Using the Step button may help to see what happens - for example that Excel keeps jumping back and forth between two values.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Goal seek displays 2 results! (Excel 2002)

    As usual, tx for the explanation! Much appreciated!
    Regards,
    Rudi

Posting Permissions

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