Hello
I have a target function varies with two parameters. I want to change the parameters so that the target value becomes minimum within the range [0,1]. It means 0 is preferred for target value but if it couldn't reach 0 by changing the parameters, a value less than 0 is also Ok. I wrote the following lines but for some cases (columns) I see a big value. Shouldn't it be less than 1? Thanks
SolverOk SetCell:=ActiveCell.Address, MaxMinVal:=2, ByChange:=changev.Address, Engine:=1
SolverAdd CellRef:=ActievCell, Relation:=1, FormulaText:=1
SolverAdd CellRef:=ActievCell, Relation:=3, FormulaText:=0
Bookmarks