title: What effect has {1,0} in the IF statement logical_test, within an array function?
body: <p>Based on <a href="https://stackoverflow.com/questions/11087773/weighted-trendline/11096449#11096449">this answer</a>, I found out how to make a weighted trendline:</p>
  
  <pre><code>{=LINEST(B2:B7*C2:C7^0.5,IF({1,0},1,A2:A7)*C2:C7^0.5,0)}
  </code></pre>
  
  <p>But I don't understand how this formula works. </p>
  
  <p>What is Excel doing with <code>IF({1,0},1,x)</code>? What is <code>{1,0}</code>?</p>