ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to create constaints in solver (https://www.excelbanter.com/excel-worksheet-functions/46001-how-create-constaints-solver.html)

Supertins

how to create constaints in solver
 
Need to create a constraint in Excel Solver where the sum of all investments
into an IT project does not exceed a certain % of the total capital budget
for a 5 year period.

Mike Middleton

Supertins -

Browse to www.solver.com.

On the horizontal menu at the top of the home page, choose "Solutions" and
pick "Finance."

Take a look at the capital budgeting examples.

- Mike
www.mikemiddleton.com

"Supertins" wrote in message
...
Need to create a constraint in Excel Solver where the sum of all
investments
into an IT project does not exceed a certain % of the total capital budget
for a 5 year period.





All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com