title: Formula to Detect and Alter Numeric Value with Decimal
body: <p>I have a project, in which after a few multiplications, a number value might end with #.25 #.50 or #.75. I would like to know if there is a way that Excel can detect the .25 or .75, in which case I would like it to erase the .25 or change the .75 to .5.</p>
  
  <p>Example: Value is <code>213.25</code> ; I would like the value to be changed to <code>213</code>.</p>
  
  <p>Or: Value is <code>551.75</code> ; I would like the value to be changed to <code>551.5</code>.</p>