I am developing a production simulation using OpenSolver in Excel. I know that I cannot use if, or, and statements to constrain a solver.

I need a constraint that says:

X has to be within the range of 150 - 250, or X can equal 0.

I have read about different ways to substitute binary constraints for conditional formulas, but I am not sure how to make it work exactly.

Any help is greatly appreciated.