MS Solver Error. Not working.

[Henrique Miranda]

Hi everyone.

I've a sheet with many conditional formulas. The result I want to obtain maximum value is based on five variables, three of them are percentual values and the other two are integer.

I'm trying to use Solver, but after the execution the result shows very slight difference, in decimals of the percentual variables. However, the result isn't correct, because changing manually the variables I already get best results.

What could be wrong?

[#2]

Rounding numbers then multiplying them should create some gap. Try to use the highest number of decimals you can, then operate with the formulas to remove the most division you can. Then trace a curve between expected results and actual results to localize where the problem is.

[#3]

I tested your advice, but didn't work. The percentual cells were slightly changed, but not the integer cells who has more potential to maximize the result I'm looking for. I tried use Solver only changing a cell with integer value, but didn't work as well. The integer cell didn't suffer any change at all.