Hello all,
is there a way in the Excel Solver to get a result within a certain range? I have some a combination of several Multiply & Divides (plus afterwards an ABS) and I need to get into a resulting area from 0..5.
Setting up the solver and constraining it for the variables works. However what I am missing is a way to communicate the desired result-window to the tool. Any idea?
An idea that I tried was with an additional IF-statement, if result > 5 then the cell would be 1, otherwise it would be 0. But that caused the solver to not find anything.
Cheers
Moadll
Bookmarks