title: Excel multiple if function for 70 logical test
body: <p>i'm about to use the if function in excel 2007 for these criteria:</p>
  
  <pre><code>if B1 = "A" then C1 = "1"
  if B1 = "B" then C1 = "2"
  if B1 = "C" then C1 = "3"
  if B1 = "D" then C1 = "4"
  .
  .
  .
  .
  if B1 = "BP" then C1 = "68"
  if B1 = "BQ" then C1 = "69"
  if B1 = "BR" then C1 = "70"
  </code></pre>
  
  <p>and for the formula, this is what i usually used:</p>
  
  <pre><code>=IF(B1="A",C1="1",IF(B1="B",C1="2",IF(C1="C",C1="3",..and so on...)))
  </code></pre>
  
  <p>but when there have to be 70 logical tests like this, is there any other formula that is easier to use?</p>
  
  <p>i hope my question is clear, and sorry if it already asked, i've tried search before asking but cant find something. thanks :)</p>