Solver and decimals HELP!

[ctj0215]

Hey-

Lets see if you guys have a solution to this problem. I have a pretty basic solver modle set up. The modle works great but my biggest problem is that the model gives me values with like 15 decimals. I need the values that it gives me values to be whole numbers. Any reccomendations?

I tried using a data-validation to set it up as whoole numbers only but solver keeps inserting the non-whole nnumbers anyway.

PLEASE help... I have to get this forecast in soon. THANKS!!

-c

 

[plettieri]

Hi:

Have you looked at the round functions?

plettieri

 

[GorD]

It would help if you could post what you have already - how have you set solver up?

 

[tusharm]

Add a constraint in Solver that indicates the desired variables must be integers.

Hey-

Lets see if you guys have a solution to this problem. I have a pretty basic solver modle set up. The modle works great but my biggest problem is that the model gives me values with like 15 decimals. I need the values that it gives me values to be whole numbers. Any reccomendations?

I tried using a data-validation to set it up as whoole numbers only but solver keeps inserting the non-whole nnumbers anyway.

PLEASE help... I have to get this forecast in soon. THANKS!!

-c