How to add greater than in Excel Solver

Question

I have a linear constraints as X>Y, and I need to add it into Excel Solver. But the option in add-in just have >=, <= or =. So what should I do?

Answer 1

Great question. You can try adding 1 or some other number to the Y value constraint portion in solver. For example if X=3 and Y=3 but we tell Solver the constraint is that X >= Y+1 then solver will flag X=3 and Y=3 because it does not meet the constraint because X would need to be 4 to meet the criteria. Adding that number to the Y portion will always ensure X>Y.