title: Excel 2010 If Cell = N/A then value from another cell, if not N/A then value from a different cell
body: <p>I need a formula in cell D1 to read </p>
  
  <pre><code>if cell A1 = N/A and B1 = 0 or &lt; 1 
      then use value from B1
  if not N/A and &lt;&gt; 0 or &gt; 1 
      then use value from C1
  </code></pre>
  
  <p>Any suggestions?</p>
  
  <p>I would like to add another condition to =IF(AND(B2&lt;>"N/A",OR(C2&lt;1,C2=0)),I2,C2).
  I need to add another OR clause stating B2&lt;>"N/A" and C2>0, then L2 has to be 0. Is this possible?</p>