How to Change rounding precision from .5 to .25

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?
 
J

John C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round Function 5
How can I alter the rounding rules? 3
How Excel to do calculations using more than 12 digits precision? 7
Rounding problems when using excel 2
Rounding Up question 2
How do I correct rounding errors in Excel formulas? 1
Round up or down to nearest 5, but not 10 2
if function with rounding 4

Top