+ Reply to Thread
Results 1 to 2 of 2

Find a set of amounts that match a target value with Solver

  1. #1
    Registered User
    Join Date
    07-20-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    2

    Find a set of amounts that match a target value with Solver

    So I tried to use Solver to get some values from a subset of values to match a value. The problem is it only works with exact values, but if I have a number like 131.76 and i want something close to it like 131.99 what do i type in Solver?

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,657

    Re: Find a set of amounts that match a target value with Solver

    You add constraints. I would recomend that you use cells as reference i.e. add 131.99 in cell B2 and if your target cell is D5

    you specify the constraint D5 <= B2

    And if you add 131.3 in B3 you could the set a min and a max value for D5 by adding constraint D5 >= B3

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find a set of amounts that match a target value
    By TexasBobcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2016, 10:28 AM
  2. Find a set of amounts that match a target value
    By TexasBobcat in forum Excel General
    Replies: 1
    Last Post: 05-04-2016, 09:55 AM
  3. Solver is not changing values in target cell using through VBA
    By brajpalshishodia in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-19-2015, 02:52 PM
  4. Replies: 11
    Last Post: 10-30-2013, 02:11 PM
  5. Solver constraints shall be OR // Solver target cell
    By Cunner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2009, 04:28 AM
  6. [SOLVED] Several target cells in the solver
    By omathilde in forum Excel General
    Replies: 3
    Last Post: 01-27-2006, 08:45 AM
  7. Goalseek / Solver Target Value
    By msnews.microsoft.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2005, 09:45 AM

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