Solver rounding
 

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!

Solver rounding
 

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

In article ,
says...
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!