title: Excel 2013 Forumla Not Working in some Cells
body: <p>SO I'm trying to get some work done in Excel 2013, and after getting an initial formula to work, I dragged it across several other cells. I did all the standard locking of references and such, even copied the exact formula into the new cell formula window with copy paste. The formula works in the first cell, not in those it's dragged over. It also works in seemingly random cells when pasted around (see screen shot).</p>
  
  <p>Formula is below... this was a brand new sheet, the cells had not been initialized until the formula was pasted. Is this an issue with Excel 2013? Since the formula works in some pastes perfectly, and not in others, I don't think that's the issue... I changed the cell format after the pastes in a couple cells to see if that changed results at all - it does not.</p>
  
  <p>Update: I added in the false value, and the IF is evaluating to false on the zero cells... why it's correctly true in some, and false in others is still a mystery.</p>
  
  <pre><code>=MIN(IF('Metrics'!$DL$2:$DL$1725=$L$2&amp;$O$2,'Metrics'!$DH$2:$DH$1725))
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/yLkRf.png" alt="enter image description here"></p>