title: Error in filter function in google spreadsheet
body: <p>I am new to google spreadsheet functions and trying to apply function as under:</p>
  
  <p>I have sheet1 &amp; sheet2 in one workbook (name-formula).</p>
  
  <p>I want to display filtered column data from sheet2 &amp; range C1:C6 in sheet1 and cell A2, formula mentioned is as under:</p>
  
  <pre><code>=filter(Sheet2!C1:C6, (D1:D6&gt;= E1) * (D1:D6 &lt;= E2))
  </code></pre>
  
  <p>Now concern is that data is loading as per function but it is not as per set criteria i.e. it is not in between E1 &amp; E2</p>
  
  <p>Please look the following link for detail</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1OU04KcKUkUpJbPZ6m3yXhS0CO1xYEkwk9Wq-g4WauiQ/edit#gid=0" rel="nofollow">https://docs.google.com/spreadsheets/d/1OU04KcKUkUpJbPZ6m3yXhS0CO1xYEkwk9Wq-g4WauiQ/edit#gid=0</a></p>