Results 1 to 3 of 3

Excel Solver - Multiple By Changing Variables

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Excel Solver - Multiple By Changing Variables

    Hi All,

    Attached is a document where I know what I want to do, but have no idea how to get Solver to do it.

    For the "Q7)" tab, for example, I need to use Solver to get the minimum value of $I$52 by changing $E$52 (which has a constraint that it equals 282.1) and also $I$52 is less than or equal to 12.

    Is someone please able to help me with this? Am I able to rearrange it in some way that will allow me to do this without too much hassle?

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Solver Max Value for Variables
    By bhutta223 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-13-2018, 10:10 AM
  2. Replies: 4
    Last Post: 01-01-2017, 07:38 PM
  3. Excel Solver - 2 Variables , Whole Numbers
    By mcp77 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-24-2016, 11:09 AM
  4. excel solver binary variables
    By kingkong123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2011, 01:59 PM
  5. using variables in excel solver constraints problem!
    By 77anders in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-12-2009, 08:49 PM
  6. Replies: 1
    Last Post: 08-08-2006, 01:00 PM
  7. [SOLVED] variables in excel solver for vba
    By suprmodl29@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2006, 10:50 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