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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver Error 3
Solver with If-Then-Else? 1
Another solver question 1
Including Solver Tool in a Macro 2
using Solver add-in 6
Need advice on Solver loop 1
Solver VBA - Defining Solver Options 5
Optimization Modeling with Excel Solver 1

Back
Top