Results 1 to 5 of 5

Excel 2007 : SOLVER: how do constraints work?

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    5

    Talking SOLVER: how do constraints work?

    In the attached file, I want to use solver to:

    Maximize G29

    by modifying only these cells: E18, E23, E25


    with the constraint that:

    E29 (the sum of E17:E25) = 3,355,000 exactly



    I submit my objective, variables to modify, and constraint...but it keeps giving me an error without specifying what the problem is.

    Help, please!



    ps- the problem is on the first worksheet in the workbook.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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