Hi again,
Thanks everyone for the tips. I tried everything that has been suggested and the problem still persists. In response to a question above, I actually need to minimise [a]-[b] subject to the answer being positive; so absolute value isn't going to help (nonetheless, I tried it and...
Hi everyone,
I'm encountering an issue with Excel Solver giving me an incorrect solution to an optimization problem.
My objective function is f() = [a] - [b]; where both a and b are a function of a third variable - time (specifically, number of years). My constraint on f() is that it is >= 0...