Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to use only integer variables in Solver of Excel 2010? (https://www.askmehelpdesk.com/showthread.php?t=572087)

  • Apr 22, 2011, 12:47 PM
    rafid11
    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.

  • All times are GMT -7. The time now is 06:02 PM.