How to Change rounding precision from .5 to .25

  • Thread starter Thread starter sBlack
  • Start date Start date
S

sBlack

I need to change the way Excel rounds numbers to round numbers that are .25
and lower down and .26 and higher up. Currently Excel rounds .49 and lower
down and .50 and higher up.
Is it possible to do this or to write a function that will do this?
 
Just add 0.24 to your number before rounding.

=ROUND(A1+0.24,0)
25.25=26
25.24=25
I post that because your header indicated that you may want 25.25=26, in
which case, just add 0.25 instead of 0.24
 
Back
Top