![]() ![]() In SolverAdd, Relation:=1 is equivalent to "less than or equal to" or "=". Cell $B$14 contains the value 8000 which is your maximum value. Another guess - Cell $B$13 contains the value 5000 which is your minimum value for Pi.Another guess, you probably want to constrain $C$5 in a similar way that you constrained $D$5 and $E$5.In SolverOK, where you have B圜hange:="C5:E7", I suspect you want B圜hange:="C5:E5", and that you want the row to increment with the counter i. set a cell by changing 3 other cells", but your code is changing 9 cells. Therefore, ValueOf is ignored and can be omitted. ![]() In the SolverOK statement, MaxMinVal:=2 is the specification to minimize.In the SolverOK statement, you should explicitly specify the Engine.Although not strictly necessary ,it is simpler to not use ranges for SetCell and CellRef.I think your set up has other problems, but it's hard to tell without seeing the rows/columns in your screen cap, or knowing the formula - specifically for column I. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |