View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default How to Change rounding precision from .5 to .25

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

--
John C


"sBlack" wrote:

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?