title: Can i add three diferent rules to a query function?
body: <p>I have two different QUERY functions, one is using two different rules, and the other uses only one. Is there a way to merge the two?</p>
  <p><strong>The first one uses a validation list of names to generate the results:</strong></p>
  <pre><code>=QUERY('Respostas Formulário'!A:L;
   &quot;where A &gt;= date '&quot;&amp;TEXTO(E2; &quot;yyyy-mm-dd&quot;)&amp;&quot;' 
      and A &lt;= date '&quot;&amp;TEXTO(F2; &quot;yyyy-mm-dd&quot;)&amp;&quot;'&quot;&amp;
   IF(B2=&quot;Todos os Mestres&quot;;;&quot; and B = '&quot;&amp;B2&amp;&quot;'&quot;); 1)
  </code></pre>
  <p><strong>The second one uses another validation list to generate a similar result:</strong></p>
  <pre><code>=QUERY('Respostas Formulário'!A:L;
   &quot;where A &gt;= date '&quot;&amp;TEXTO(E2; &quot;yyyy-mm-dd&quot;)&amp;&quot;' 
      and A &lt;= date '&quot;&amp;TEXTO(F2; &quot;yyyy-mm-dd&quot;)&amp;&quot;'&quot;&amp;
   IF(C2=&quot;Todas as Tasks&quot;;;&quot; and D = '&quot;&amp;C2&amp;&quot;'&quot;); 1)
  </code></pre>
  <ul>
  <li>Is there any way to use both the date, the info in B2, and the info in C2 to generate a query?</li>
  </ul>