title: Excel Solver: Is there a way to iterate over 2 changing variables?
body: <p>I have an issue with solver as follows (simplified version):
  So I have a nested If statement that describes condition for 2 changing variables(x,y). For example:
  In one cell: IF(AND((x&lt;=2),(x>=0.5),(y&lt;=10),(y>=5)),1,0<br>
  The cell below it: IF(AND((x&lt;=2.5),(x>=1.9),(y&lt;=11),(y>=9)),1,0<br>
  The objective function is the sum of these 2 variables<br>
  Solver or goal seek (unless i give it the awnser) can't seem to get an awnser other than 0,0. 
    My actual problem is that i have 6 of these IF cells and I'm trying to find an (x,y) that maximizes my objective function. I want excel to go through as many combinations it can. </p>
  
  <p>Any thoughts or other ways to do this? Thanks. </p>