dimanche 29 janvier 2017

If Linear Programming Decision Variable >= 0 then >= 3000

I am trying to use the solver in Excel to create a linear program to minimize mutual fund expenses. My decision variables are the amounts invested in each fund. If anything is invested, it must meet the fund minimum. How can I program this?

Amount invested in Fund 1 >= if Amount Invested in Fund 1 > 0, then Amount Invested in Fund 1 >= 3000 else Amount Invested = 0

Any help is greatly appreciated. Thanks.

Aucun commentaire:

Enregistrer un commentaire