| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| Resetting Solver Manually to Fix Solver Bug | Excel Programming | |||
| solver | Excel Programming | |||
Hybrid Mode
