Add multiple constraints on Excel Solver

Question

In excel solver,i need a variable to either be zero or lie between 50% of max to 100%. i.e it should not lie between 0 to 50% but can be zero. how to add a constraint like this?

Answer 1

Add a dummy variable in another cell with a formula that returns a 1 when the primary variable is 0 or 0.5-1, and returns 0 any other time.

Then put a constraint on this dummy variable, so that it must be 1 in an accepted solution.