title: Google sheet Query Function Returns blank result from cell with data
body: <p>I am creating a spreadsheet for my work place that will find drivers for the LED's we use but I've run into a slight problem. i pull in the data from another sheet to thin it out, i then have a sheet for formulas, one for the form, and the data on its own sheet. for some reason, i do a calculation on one sheet, then use the query function to return that result on another sheet, but the result sometimes misses data.</p>
  
  <p>I am using this formula to determine how many LED's can be attached to the driver:</p>
  
  <pre><code>=IF(A4="","",IF(U4="Y",If(K4&gt;1,IF(round(O4)=round(P4),P4&amp;" per Channel",O4&amp;"-"&amp;P4&amp;" per Channel"),IF(round(O4)=round(P4),P4,O4)),IF(U4="Min+1",If(K4&gt;1,IF(round(O4+1)=round(P4),P4&amp;" per Channel",(O4+1)&amp;"-"&amp;P4&amp;" per Channel"),IF(round(O4+1)=round(P4),P4,(O4+1)&amp;"-"&amp;P4)),IF(U4="Max-1",If(K4&gt;1,IF(round(O4)=round(P4-1),O4&amp;" per Channel",O4&amp;"-"&amp;(P4-1)&amp;" per Channel"),IF(round(O4)=round(P4-1),P4,O4&amp;"-"&amp;(P4-1)))))))
  </code></pre>
  
  <p>I then use this function to display a list of all the drivers that will work, but the result of the previous formula, even though it displays on the formulas sheet, will not display on the forms sheet.</p>
  
  <pre><code>=IFERROR(if($C$3="Y",if(BFFormulas!R1="CC",query(BFFormulas!A3:Z900,"select A,B,D,H,I,K,Q,L where A != '' and J='Y' and N = 'Y' order by D ",1),if(BFFormulas!R1="CV",query(BFFormulas!A3:Z900,"select A,B,D,H,I,K,Q,L where V &gt; "&amp;BFFormulas!T1*D3&amp;" and A != '' and J='Y' order by D ",1),"Missing Fixture Information")),if(BFFormulas!R1="CC",query(BFFormulas!A3:Z900,"select A,B,D,H,I,K,Q,L where A != '' and N = 'Y' order by D ",1),if(BFFormulas!R1="CV",query(BFFormulas!A3:Z900,"select A,B,D,H,I,K,Q,L where V &gt; "&amp;BFFormulas!T1*D3&amp;" and A != '' order by D ",1),"Missing Fixture Information"))),"Could Not Find Fixture From This Source.")
  </code></pre>
  
  <p>Can anyone tell me why this is happening?</p>
  
  <p>Image of what happening:
  <a href="https://drive.google.com/file/d/0Bw6otjO0spyBd2NXYWhuQm1QbnM/view?usp=sharing" rel="nofollow">https://drive.google.com/file/d/0Bw6otjO0spyBd2NXYWhuQm1QbnM/view?usp=sharing</a></p>