Rounding - but not as you know it.

[kgkev]

I have a column of decimal number that I want to round to the nearest whole number.

However I don't want to round at the half way point.

If the number is 0.25 - 0.99 I want to round up.

If it is 0.01-0.24 I want to round down.

How do I do this?

Example of my numbers


0.7407407 UP
0.5185185 UP
13.5111111 UP
7.7777778 UP
2.6740741 UP
6.8888889 UP
1.5925926 UP
4.845679 UP
0.4876543 UP
10.0111111 DOWN!!!!!
8.9027778 UP
3.9814815 UP

 

[Andrew Poulsom]

Isn't it eg?

=ROUND(A1+0.25,0)

 

[njimack]

=if(a1-int(a1)>=0.25,roundup(a1,0),rounddown(a1,0))

 

[kgkev]

I always imagine its going to be a nice complicated forumla.

Thanks for that!!

 

[kgkev]

=if(a1-int(a1)>=0.25,roundup(a1,0),rounddown(a1,0))

Thats more like it!!!!

Probably stick with Andrews though...