title: Excel evaluation formula false when it should be true
body: <p>Trying to create a table in Excel for <a href="http://en.wikipedia.org/wiki/Mnemonic_major_system" rel="nofollow">Mnemonics Major System</a> to practice. Excel is evaluating a formula false when it should be true.</p>
  
  <pre><code>=IF(Q2=0,"Z",IF(Q2=1,"T", IF(Q2=2,"N",IF(Q2=3,"M",IF(Q2=4,"R",IF(Q2=5,"L",IF(Q2=6,"J",IF(Q2=7,"K",IF(Q2=8,"F",IF(Q2=9,"P"))))))))))
  </code></pre>
  
  <p>Q2 is filled in by this formula:</p>
  
  <pre><code>=MID(O2,1,1)
  </code></pre>
  
  <p>Which references a random set of 4 digit numbers. The error when I evaluate the formula is <strong>"2"=2</strong></p>
  
  <p>My goal is to convert for numbers to characters in the Major System to letters, and then hide the letters with formatting so I can plug in what I think the answer is and Excel should validate.</p>