precision in solver
Randi" wrote:
Hi.. Does anyone know what the precision means when
you run the solver? We have to change the number from
0,000001 to 0,001 before solver could find an optimal
solution but I don't know how this affect the solution.
It may or may not have. Most numbers with decimal fractions cannot be
represented exactly in the internal form that Excel uses (binary
floating-point). This is especially true of computed values. So it is very
common that when we intend to test the equality of two numbers, A and B, we
actually test ABS(A-B)<=precision -- that is, "is the difference within some
precision?". I believe this is how Solver uses the Precision option.
|