title: Output value based on number range entered in excel
body: <p>I need to find a formula that I can use for any number, and have it output a number identified to correspond to that range. </p>
  
  <p>For instance, I need to be able to input:</p>
  
  <p>A number >2.50 and  &lt;7.49, and the formula spit out $0.05</p>
  
  <p>A number >7.50 and  &lt;24.49, and the formula spit out $0.10</p>
  
  <p>A number >25.00 and  &lt;74.99 and the formula spit out $0.50, and so on/so forth.</p>