title: ArrayFormula and "AND" Formula in Google Sheets
body: <p>In Google Sheets, when using ArrayFormula with AND formula, I don't get the results as it should be.</p>
  
  <pre><code>A|B
  2|7
  </code></pre>
  
  <p>In <code>C1</code> I put formula as: <code>=and(A1&gt;5,B1&gt;6)</code> then I get <code>True</code>. If in D1 I put formula as: <code>=ArrayFormula(and(A1:A&gt;5,B1:B&gt;6))</code> I get the results as <code>False</code>. </p>
  
  <p>Here are my two questions:</p>
  
  <ol>
  <li>Why is <code>ArrayFormula</code> not repeated for all cells in the column?</li>
  <li>Why do I get <code>true</code> without <code>ArrayFormula</code> and <code>False</code> with <code>Arrayformula</code>?</li>
  </ol>