Excel: Solver Cannot Constrain Value to Multiple of a Value

Last reviewed: November 30, 1994
Article ID: Q78756
The information in this article applies to:
  • Microsoft Excel for Windows versions 3.0, 4.0
  • Microsoft Excel for OS/2 version 3.0

SUMMARY

The Solver program that comes with Microsoft Excel cannot force an adjustable cell value to be a multiple of a specified value. The Set cell value also cannot be constrained to a multiple of a certain value in a Max or Min problem.

MORE INFORMATION

Often, it would be desirable to have the adjustable variables or optimal solution of a Solver model result in a multiple of a certain value. One example is an investment transaction to purchase bonds in $1000 lots. It may be impossible to purchase $750 of a bond with a $1000 face value; thus, a result that is a multiple of 1000 would be more appropriate.

To constrain an adjustable cell to a multiple of another value, the MOD function, with the adjustable cell as the number argument and the multiple as the divisor argument, would be constrained to a value of zero. Solver is not able to "back-solve" (that is, calculate the inverse for) this type of model.

REFERENCES

"Microsoft Excel Function Reference," version 3.0, page 155

"Microsoft Excel Solver User's Guide," version 3.0, page 13


KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 3.0 4.00 4.0


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.