title: Excel Formula if | and
body: <p>I need some help with an Excel formula</p>
  
  <pre><code>╔═══════════════╦═════════╗
  ║   SALE PRICE  ║  Bonus  ║
  ╠═══════╦═══════╬═════════╣
  ║   0   ║ 14999 ║  $25.00 ║
  ╠═══════╬═══════╬═════════╣
  ║ 15000 ║ 20000 ║  $50.00 ║
  ╠═══════╬═══════╬═════════╣
  ║ 20001 ║ 25000 ║ $125.00 ║
  ╠═══════╩═══════╬═════════╣
  ║     25001+    ║ $250.00 ║
  ╚═══════════════╩═════════╝
  </code></pre>
  
  <p>The above table is the data I need to extract when the sale price is entered into a field.</p>
  
  <p>For example.....</p>
  
  <p>Cell <code>D24</code> is the BONUS FIELD
  Cell <code>E29</code> is the SALE PRICE FIELD</p>
  
  <p>If the sale price is between <strong>$0-$14,999</strong>, then I want cell <code>D24</code> to auto-populate <strong>$25.00</strong>. Then, if the sale price is between <strong>$15,000-$20,000</strong> I want Cell <code>D24</code> to auto-populate <strong>$50</strong>. Then, if the sale price is between <strong>$20,001-$25,000</strong> I want Cell <code>D24</code> to auto-populate <strong>$125</strong>. Then finally, if the sale price is <strong>$25,001+</strong> I want Cell <code>D24</code> to auto-populate <strong>$250</strong>.</p>