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.