title: Round numbers based on ending digit in Excel
body: <p>I need a formula in excel to round my price list.</p>
  
  <p>Last digit of my price ends with</p>
  
  <p>0-1-2 = 9 (Example: if price is $50-$51-$52 will be $49)(subtracts)</p>
  
  <p>3 = 4 (Example: if price is $53 will become $54)(add 1)</p>
  
  <p>4 = 4 (Example: if price is $54 will be the same $54)</p>
  
  <p>5 = 5 (Example: if price is $55 will be the same $55)</p>
  
  <p>6-7-8 = 9 (Example: if price is $56-$57-$58 will be $59)(adds)</p>
  
  <p>9 = 9 (Example: if price is $59 will be the same $59)</p>
  
  <p>My price starts from $8 to $1,106.</p>
  
  <p>Thanks and I appreciate your help.</p>