title: IF function with 3 conditions
body: <p>I'm looking to create a formula with 3 conditions. It is currently only working with 2 conditions. Here's what I'm looking for:</p>
  
  <p><code>E9</code> has a number </p>
  
  <p>If the number is <code>21+</code> then I want it to show Text <code>1</code></p>
  
  <p>If the number is between <code>5 and 21</code>, then I want it to show Text <code>2</code></p>
  
  <p>If the number is below <code>5</code>, then I want it to show Text <code>3</code></p>
  
  <p>This is what I currently have: </p>
  
  <pre><code>=IF(E9&gt;21,"Text 1",IF(E9&lt;21,E9&gt;5,"Text 2")
  </code></pre>
  
  <p>When I try and add the final condition, it gives me an error that I've entered too many arguments for this function. When the number is below 5 it shows False.</p>
  
  <p>I would prefer a solution that does not use <code>VLOOKUP</code>. </p>
  
  <p>I'm not understanding why it's saying this is not allowed, I have another IF function with 5 nested formulas that works just fine. </p>