title: Excel check and replace the digit after decimal
body: <p>I have a figure in Excel. For example <code>Cell A1: 241.86</code>. </p>
  
  <p>How do I check and change the last digit. For example, if it is greater or equal to 6 then replace it to 5, else remain the same. <code>Eg: 241.86 to 241.85.</code></p>
  
  <p>I have tried the following:</p>
  
  <pre><code>=IF(MID(A1,FIND(".",A1)+2,5)&gt;=6,REPLACE(A3,3,2,A1-0.01),A1)
  </code></pre>
  
  <p>The above formula doesn't work, whenever its 241.86 or 241.84 the result will be 241.85 and 241.83. It simply minus 1 from the last digit. Any help will be appreciated.</p>