Discussion Re: Running solver on 4 variable equation in Excel
https://techcommunity.microsoft.com/t5/excel/running-solver-on-4-variable-equation/m-p/1674433#M75095
<P><LI-USER uid="794485"></LI-USER> </P><P>You need to specify a target value, since you said you can slightly increase over 300112, I assumed you mean 10% more. We can add a constraint the the OF < 1.1*300112</P><P> </P><P>I also assumed when you said you wanted to max A more than B and B than C, each is 10% more. add them as constraints. </P><P> </P><P>You will get an optimal value this way. please see my implementation</P><P>hope it makes sense ..</P><P> </P><P>waiting for your feedbak</P>Wed, 16 Sep 2020 17:23:03 GMTRamiz_Assaf2020-09-16T17:23:03ZRunning solver on 4 variable equation
https://techcommunity.microsoft.com/t5/excel/running-solver-on-4-variable-equation/m-p/1669613#M74976
<P>I have a 4 variable equation 24A+22B+20C+14D=300,123 so i set my equation =(24*B4)+(22*C4)+(20*D4)+(14*E4) as my set objective. I would like to get as close to 300,123 as i can, my objective is to be >= 300,123. I have set my A, B and C variables as int because they need to be whole numbers, I also want to prioritize A as high as possible (maxed) with B as second maxed ect. attached is an image of what i have so far. Im thinking that my function can not be set to "value of" because i am allowed to go slightly higher and that A should be set to max, but A is not a formula. Thoughts?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tpitera_0-1600186610657.png" style="width: 400px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/218408i5A8AAA74EE9C4D2A/image-size/medium?v=v2&px=400" role="button" title="tpitera_0-1600186610657.png" alt="tpitera_0-1600186610657.png" /></span></P><P> </P>Tue, 15 Sep 2020 16:19:56 GMThttps://techcommunity.microsoft.com/t5/excel/running-solver-on-4-variable-equation/m-p/1669613#M74976tpitera2020-09-15T16:19:56ZRe: Running solver on 4 variable equation
https://techcommunity.microsoft.com/t5/excel/running-solver-on-4-variable-equation/m-p/1674433#M75095
<P><LI-USER uid="794485"></LI-USER> </P><P>You need to specify a target value, since you said you can slightly increase over 300112, I assumed you mean 10% more. We can add a constraint the the OF < 1.1*300112</P><P> </P><P>I also assumed when you said you wanted to max A more than B and B than C, each is 10% more. add them as constraints. </P><P> </P><P>You will get an optimal value this way. please see my implementation</P><P>hope it makes sense ..</P><P> </P><P>waiting for your feedbak</P>Wed, 16 Sep 2020 17:23:03 GMThttps://techcommunity.microsoft.com/t5/excel/running-solver-on-4-variable-equation/m-p/1674433#M75095Ramiz_Assaf2020-09-16T17:23:03Z