title: excel "IF" formula returning "0" (it shouldn't)
body: <p>Here's the formula</p>
  
  <pre><code>=IF(
      AND(
          NOT(ISERROR(Table3[[#This Row],[lot_ID]])),
          Table3[[#This Row],[uniquness]]="unique"
      ),
      LEFT(Table3[[#This Row],[lot_ID]],3),
      "junk"
  )
  </code></pre>
  
  <p>Below is the formula evaluation (some middle steps omitted. The last two contain the puzzle.)</p>
  
  <p>The mystery has really got me. </p>
  
  <p><img src="https://i.stack.imgur.com/kO8TP.png" alt="step 1"></p>
  
  <p><img src="https://i.stack.imgur.com/y8BIQ.png" alt="Step 2"></p>
  
  <p><img src="https://i.stack.imgur.com/HeNPI.png" alt="Step 3..."></p>
  
  <p><img src="https://i.stack.imgur.com/mscY6.png" alt="...Step 8"></p>
  
  <p><img src="https://i.stack.imgur.com/c55d1.png" alt="Step 9"></p>