title: IF Function with 3 conditions and outcomes
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>A1 has a number</p>
  
  <p>If the number is >15 then I want it to show Text 1</p>
  
  <p>If the number is between 10 and 15, then I want it to show Text 2</p>
  
  <p>If the number is between 5 and 10, then I want it to show Text 3</p>
  
  <p>If the number is lower than 5, I don't want anything</p>
  
  <p>Anybody got an idea?</p>