Aug 13 2018 07:12 AM
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?
Aug 13 2018 12:26 PM - edited Aug 13 2018 12:26 PM
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.
Aug 13 2018 01:14 PM