XL5: Incorrect Limit on Number of Solver Constraints |
For each problem, you can specify two constraints for each changing cell (one upper-limit and one lower-limit constraint), plus up to 200 additional constraints.This limit on constraints is incorrect. The correct number of additional constraints, as indicated in the Microsoft Excel Help, is 100. If you enter more than 100 constraints, you will receive the following alert message:
For more information about Adding, Changing, Or Deleting Constraints in Solver, choose the Search button in Help and type:Too many constraints
Solver Constraints
"User's Guide," version 5.0, pages 566-567
Additional query words: SOLVER max maximum tolerance
Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :
|
Last Reviewed: September 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |