title: Excel IF Statements Table Format
body: <p>Can somebody help me with the following IF statement please. 
  I tried the following</p>
  
  <pre><code>IF(A2="",D1,IF(D1="",A1,IF(A2=A2,"",D1)))
  </code></pre>
  
  <p>but it doesn't seem to produce correct answer. </p>
  
  <p>Unfortunately i can't post my excel s/h image.</p>
  
  <p>I need to make sure that</p>
  
  <pre><code>IF (Cell = number)
    //return as blank
  ELSE IF(Cell = no number)
    // return number from Cell that has the number
  </code></pre>
  
  <p>Thanks</p>