+ Reply to Thread
Results 1 to 4 of 4

Using Excel Solver with Min & Maximum

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    3

    Using Excel Solver with Min & Maximum

    Hi Everyone,

    I'm having issues getting solver to use the minimum and maximum for hours and items to be produced. I can't seem to get a balance between the two.

    Thank you for the help

    Solver 1.xlsx

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Using Excel Solver with Min & Maximum

    Is it because they are text and not numbers?
    I'm not sure what you are trying to achieve and how. There are no formulas on the sheet.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    01-27-2014
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Using Excel Solver with Min & Maximum

    I removed the formulas because the whole thing was just an error. I'm trying to get the optimal units to be produced for the best profit

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Using Excel Solver with Min & Maximum

    Is this your homework? Try and put in some formulas and I will comment on them.

+ 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. How to get maximum production by using solver
    By amolryeolekar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2013, 11:53 AM
  2. Replies: 4
    Last Post: 02-10-2012, 03:48 PM
  3. Please how can I aske solver to take the maximum value always
    By nlpman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2012, 07:30 PM
  4. Replies: 1
    Last Post: 08-08-2006, 01:00 PM
  5. solver- maximum profit
    By smallsun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2005, 12:06 PM

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