title: Rounding to a specific number ex: 4 ,5, 9 ,0 sql
body: <p>I have prices that are going to be converted from one currency to several other currencies but once they are converted I would like to round them to a specific number.</p>
  
  <p>The examples on what I need to round are the following :</p>
  
  <p>Anything under 10 round to the next digit. For this I can just use the CEILING function.
  Anything between 10-14 needs to rounded to 14.00. ex: 12.78 to 14.00
  Between 14.01 and 15 needs to rounded to 15.00. ex: 14.25 to 15.00 
  Between 15.01 and 19 needs to be rounded to 19.00 ex: 17.35 to 19.00
  Between 19.01 and 20 needs to rounded to 20.00. ex: 19.25 to 20.00 </p>
  
  <p>I know this seems a little weird but it is a specification I've been given for my project. To round to the next multiple of 5 I also understand but it is the 4 and 9 values that are really stumping me. </p>
  
  <p>What formula would I need to use to obtain these numbers, or would it be easier to explode the number, grab the value before the decimal and do a case based on the criteria I stated above?</p>
  
  <p>Thanks for your help!</p>