title: How do I create a formula for "if x ≥ then multiply by y" and so on?
body: <p>I've only used Excel for the basics.</p>
  
  <p>I want to multiply the contents of the cell by a different number depending on the value in the cell. I have these ranges:</p>
  
  <ul>
  <li>0 - 499, then multiply by 0</li>
  <li>500 - 999, then multiply by 1</li>
  <li>1000 - 1499, then multiply by 4</li>
  </ul>
  
  <p>I was able to figure out the formula <code>=IF(C21&gt;=10000,C21*1)</code> for if a value in cell <code>C21</code> is greater than or equal to 10,000, but I don't see how to extend that to multiple ranges.</p>
  
  <p>How can I write a formula to handle the multiple ranges I've listed above?</p>