Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Change rounding precision from .5 to .25
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the precision for Pivot Table | Excel Discussion (Misc queries) | |||
Number precision | Excel Discussion (Misc queries) | |||
Decimal precision of change history? | Excel Discussion (Misc queries) | |||
Higher precision: can one get it? | Excel Discussion (Misc queries) | |||
Precision displayed does not match precision in cell | Excel Discussion (Misc queries) |