title: Tool to help write Excel formulas and IF statements?
body: <p>This is an Excel formula with nested IF statements:</p>
  
  <pre><code>=IF((B2="East"),4,IF((B2="West"),3,IF((B2="North"),2,IF((B2="South"),1,""))))
  </code></pre>
  
  <p>To essentially accomplish this:</p>
  
  <pre><code>If cell B2 = "East"
     return "4"
  
  ElseIf cell B2 = "West"
     return "3"
  
  ElseIf cell B2 = "North"
     return "2"
  
  ElseIf cell B2 = "South"
     return "1"
  
  Else
     return ""
  </code></pre>
  
  <p>Can Excel formulas be written in such a "more readable" manner and converted to the official syntax? Is there any tool to help write Excel formulas?</p>
  
  <p>This may be a "superuser" question ... but only programmers might know the answer!</p>