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
Round up or down to nearest 5, but not 10 2
Rounding Up question 2
Paragraph numbering in Word 1
rounding a number up to a certain ending digit 6
How Excel to do calculations using more than 12 digits precision? 7
How can I alter the rounding rules? 3
Rounding problems when using excel 2

Top