Hi all,
I am trying to use the solver to maximize a function.
Attached you will find the model.
1. Range A1:N10 is given
2. Range A17:O26 is the new range
3. Variables are in D18:D26
4. Variable 14 (O18:O26) contains the equations to consider as defined in cells I33:I40 where x in cell I33 would be equal to (D18/D2-1) -> cell O18
5. The objective : maximize the sum of rows for variable 11 - L18:L25
6. The constraints are defined from row 48 (e.g. B50 <= C50 and so on depending on upper or lower bound)
I am having trouble in setting up the solver to maximise this function given these constraints but can't find what is the issue.
Many thanks in advance for your help.
Bookmarks