Closed Thread
Results 1 to 3 of 3

GRG Nonlinear vs. SimplexLP in Solver

  1. #1
    Registered User
    Join Date
    06-07-2011
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    21

    GRG Nonlinear vs. SimplexLP in Solver

    Hi everyone,

    When I use GRG Nonlinear, I get a local max based off of my objective function, and then I can set it to see all iterations. But, when I switch to Simplex LP to get the global maximum, it errors and says: One of the cells in the worksheet became an error value when Solver tried certain values for the variable cells.

    Why will GRG Nonlinear run, but not Simplex LP...I want Simplex LP so that way I can view the global maximum and not just see a local max and have joe schmoe think that the local max is the global max.

  2. #2
    Registered User
    Join Date
    10-30-2024
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    1

    Re: GRG Nonlinear vs. SimplexLP in Solver

    Hi mitts,

    I encountered this error, too. Have you find a way to fix this yet?
    Can you share it with me, pleasee <3

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,790

    Re: GRG Nonlinear vs. SimplexLP in Solver

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread, and in any case, this one is already 13 years old.

    Please see Forum Rule #1 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

Closed 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