title: Discontinuous Solver Constraint Workaround
body: <p>I am developing a production simulation using OpenSolver in Excel. I know that I cannot use if, or, and statements to constrain a solver.</p>
  
  <p>I need a constraint that says:</p>
  
  <p>X has to be within the range of 150 - 250, or X can equal 0. </p>
  
  <p>I have read about different ways to substitute binary constraints for conditional formulas, but I am not sure how to make it work exactly. </p>
  
  <p>Any help is greatly appreciated. </p>