Thread: how do you create a double condition in excel

Hi,

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

Thank you

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.

Thank you.

Sorry maybe I not specified enough in my question

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.

Thank you.
Reply With Quote