Excel Solver Question?

I need to link a binary variable so that if the binary variable is a 1, then something else must be bought, any help?? I need it tonight.





Thanks.|||You generally want to avoid using IF() statements with Excel Solver. It does not handle them well.





I am not sure you have provided enough information to fully answer the question, but I will give it a try. Say the binary cell is in Z1 and cell B1 represents the something else that must be bought if the binary is 1. If you only need force the purchase of one unit if the binary is one, then you can add the constraint:





B1 %26gt;= Z1





If you need to force it to buy 10 if the binary is 1 then add:








B1 %26gt;= Z1 * 10





Hope this helps. If not, provide some more info.|||If you need help with the simple formula, you need to pay more attention.|||use the if() function.