How to add "int" constraint in Solver?

T

TR

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm running a linear optimization in Solver and I need to add the constraint that the solution variables be integers.

I click "add" next to the constraints, select the cells in question (now blank, unsolved), and select "int" from the options. I leave the "Constraint" box blank. I get the error message "Constraint must be a number, simple reference, or formula with a numeric value."

This does not happen on a PC. Any suggestions?
 
J

JE McGimpsey

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm running a linear optimization in Solver and I need to add the constraint
that the solution variables be integers.

I click "add" next to the constraints, select the cells in question (now
blank, unsolved), and select "int" from the options. I leave the "Constraint"
box blank. I get the error message "Constraint must be a number, simple
reference, or formula with a numeric value."

This does not happen on a PC. Any suggestions?

Enter a zero (0) in the input box after setting the dropdown to "int"
 

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


Top