If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I am trying to set a constraint that for every kg of fish is eaten, 0.5kg of rice must be eaten.
A=Fish
B=Rice
Could anyone tell me how to set this constraint in excel to check
actually i am trying to use solver to solve a equation
I have fish price at $1.23
rice price at $1.24
And I set the criteria, that every 1kg of rice is eaten, 0.5 kg of fish must be eaten.
I also set a criteria that u must eat a minimum of 2kg of rice and 1kg of fish.
I am not sure how to use solver to set the constraint for below.
Any help appreciated.
Actually this is my scenario
I have fish price at $1.23
rice price at $1.24
Fish has 1 unit of fat and 2 unit of carbohydrate
Rice has 2 unit of fat and 3 unit of carbohydrate
3 criteria being set as below:
Every 1kg of rice is eaten, 0.5 kg of fish must be eaten.
U must eat a minimum of 2kg of rice and 1kg of fish.
U must also get a minimum of 3 unit of fat and 4 unit of carbohydrate.
I am not sure how to use solver to set the constraint for below.
Any help appreciated.
how do you create a double condition in excel
Linear Mode
