title: Arrayformula If And
body: <p>I'm trying to apply an array formula to one of my sheets and it is not working - the formula itself works however it isnt being applied to all the cells (the continue bit)</p>
  
  <p>This is my formula.</p>
  
  <pre><code>if(H2-F2&lt;14,1,if(and(H2-F2&gt;14,H2-F2&lt;168),14,if(H2-F2&gt;168,42,"")))
  </code></pre>
  
  <p>When I add array formula</p>
  
  <pre><code>=ARRAYFORMULA(
    if(H2-F2&lt;14,1,
      if(and(H2-F2&gt;14,H2-F2&lt;168),14,
        if(H2-F2&gt;168,42,"")
      )
     )
  )
  </code></pre>
  
  <p>It works but doesn't apply it to all cells, why is this and how do I go about making it work?</p>
  
  <p>EDIT: New formula with cell ranges</p>
  
  <pre><code>=ARRAYFORMULA(
    if(H2:H-F2:F&lt;14,1,
      if(and(H2:H-F2:F&gt;14,H2:H-F2:F&lt;168),14,
        if(H2:H-F2:F&gt;168,42,"")
      )
    )
  )
  </code></pre>