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