Results 1 to 6 of 6

optimization problem - solver falling to get correct answer

Threaded View

  1. #1
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    optimization problem - solver falling to get correct answer

    Hey,

    I have a cell (D21) with a value that, connected by some simple calculations in other cells, is dependant on three, variable cells (not containing formulas).

    When I keep the two of the three variables constant and run the solver in order to optimize the value of D21, the solver fails to find the correct solution (but finds a solution though).
    I have a hard time to see why it fails to find the correct solution, and it is highly appreciated if someone can help me with getting around this problem in some way.

    Please take a look at the attachment, which shows the problem more clearly.

    Thanks in advance for your help
    Attached Files Attached Files

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