Results 1 to 8 of 8

Solver: minimum value of two variables that result in x

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2022
    Location
    brazil
    MS-Off Ver
    365
    Posts
    8

    Solver: minimum value of two variables that result in x

    Hello once again!

    I have the following equation (changed the cells' IDs to letters):

    =((1+(A/100))*((B*((C+1)/4)*(1+(D/50))+(D*10))+80))-E

    B, C and E are fixed numbers.
    A and D are variables.

    I need the equation to be as close to 0 (zero) as possible.

    However, I need the MINIMUM combination of A and D (basically, the smaller A AND D) that would make it 0, and not ANY combination.

    How I've set up the solver so far:
    Set Objective: the formula cell
    To Value Of: 0
    By Changing Variable Cells: A and D

    Constraints:

    A and D = integer
    A and D >= 0
    Formula Cell should be >=0

    I can't solve, as it return the following error:

    Error in model. Please verify that all cells and Constraints are valid.
    Perhaps some cells that are not Variable Cells are marked as Integer, Binary or AllDifferent.

    So I am asking myself... would the solver provide me the minimum combination of A and D that will make by formula = 0, or is it trying to give me anything that makes formula = 0 and, as many combinations would be possible, it is returning me an arror?

    Any hint?

    Thank you in advance!

    EDIT 1: Solved the error by unmerging the variable cells. But the solver can't find a feasible solution.

    EDIT 2: Changed from "To Value Of: 0" to Minimum and set another constraint of Formula >=0. It returns me a solution. But the question remains: is it the minimum value of A and D or just anything that solves my problem?
    Last edited by mucura; 02-03-2022 at 07:38 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Solver- Optimal Salary Lineup- Solver does not find optimal solution
    By Sleven369 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-07-2021, 04:04 PM
  2. Replies: 5
    Last Post: 10-09-2020, 03:33 AM
  3. Replies: 2
    Last Post: 06-22-2020, 03:14 PM
  4. Excel solver - Trouble with linear programming using solver excel
    By spicyscreamer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2017, 08:01 AM
  5. [SOLVED] Excel Solver VBA - Solver Violating Constraints
    By lespaul00 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-19-2015, 04:00 PM
  6. Replies: 0
    Last Post: 09-22-2015, 06:09 PM
  7. Replies: 11
    Last Post: 10-30-2013, 02:11 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