Solver rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have found that rounding on the Excel spreadsheet prevents Solver from
solving correctly. Does anyone know how to round up figures so that Solver
will accept them as part of a linear equation? This particular equation has
integer constraints.

Thanks for any & all help!
 
By its very nature, rounding is non-linear. If you must round, specify
the problem as non-linear. Of course, that dramatically affects the
performance of Solver -- and, not in a positive manner.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top