 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
How to use only integer variables in Solver of Excel 2010?
I am trying to solve a linear programming problem using Excel 2010. I am new to this so I decided to start with a simple problem. I have put objectives, variables, constraints everything correctly. I am doing it in Simplex method. Solver solves the problem, but with the variables being in decimal form. How can I do this calculation with only integer variables, i.e. solver will change the cells with only integers? I am not an advanced Excel user, so please provide a detailed solution.
|
||||
Check out some similar questions!
What is an integer?
[ 3 Answers ]
Is a whole number still an integer even if it is written in decimal or fraction form? e.g.. Is 1.0 an integer? Is 3/1 an integer?
Time to integer
[ 1 Answers ]
what is the formula for calculating integer value of a 24 hr time format. i.e to return 2.75 for the time value of 2:45. I am using this to create a simple time sheet. time out-time in = time on job Then to multiply that by a rate to return wage Thanks
Integer
[ 3 Answers ]
why is this happening? including all necessary header files ,math.h and stdio.h , int main() { int I=2; int y=pow(10,I); printf("%d",y); return 0; }
View more questions Search
| Question Tools | Search this Question |
Add your answer here.
|
