title: Multiple IF statements between number ranges
body: <p>I'm trying to set up a formula with multiple IF statements between number ranges but I'm seeing the error:</p>
  
  <blockquote>
    <p>Formula parse error</p>
  </blockquote>
  
  <p>Here is the forumula:</p>
  
  <pre><code>=IF((AND(A2&gt;0,A2&lt;500),"Less than 500",
   If(AND(A2&gt;=500,A2&lt;1000),"Between 500 and 1000"),
   If(AND(A2&gt;=1000,A2&lt;1500),"Between 1000 and 1500"),
   If(AND(A2&gt;=1500,A2&lt;2000),"Between 1500 and 2000")))
  </code></pre>