title: Excel - AND formula not workig as excepted (Need to get value returned by formula)
body: <p>I am using this formula :</p>
  <pre><code>=IF(AND(G767&lt;&gt;0;I767=0);TRUE;FALSE)
  </code></pre>
  <p><code>G767</code> and <code>I767</code> Contains number. <strong>Why does this formula return</strong> 0 and not <code>TRUE</code> or <code>FALSE</code></p>
  <p>Sound Like <code>AND</code> Does not work as excepted</p>
  <p><strong>EDIT</strong></p>
  <p><code>G767</code> and <code>I767</code> are given thanks to Formula, I need and <code>AND</code> don't take the formula's value but only the formula so how can I select the values returned by the formula and not the formula ?</p>
  <p>Example :</p>
  <p><code>G767</code> and <code>I767</code> are given with this forumla :</p>
  <pre><code>=IF(G767&lt;&gt;0;'Primary Pricer'!$J$57*Pricing_Calculation!F761;IF(G767=0;'Primary Pricer'!$J$57*Pricing_Calculation!F761+'Primary Pricer'!$J$57))
  </code></pre>