Thank you.
I edited the formula to keep zero as zero:
=IF(A1=0,0,IF(MOD(A1,1)<=0.4,INT(A1)+1,IF((MOD(A1, 1)>0.4)*(m od(A1,1)<=0.9),INT(A1)+2,"")))
I've "stored" it in cell B1. Unfortunately I'm getting strange results when I copy-paste it into other cells. Some work, and some do not! I copied the formula into cells to the right of the cells containing the original values. Here is the result:

6.7 #NAME?
6.6 #NAME?
4.1 5
5.2 6
0 0
0 0
9 10
6.9 #NAME?
10.7 #NAME?
6.7 #NAME?
9.4 10
4.2 5
0 0
0 0
7 8
0 0
2.5 #NAME?
14.5 #NAME?
1.7 #NAME?
0 0
7.8 #NAME?
8.2 9
6.6 #NAME?
0 0
0 0
0 0
0 0
9.7 #NAME?
3.2 4
4.6 #NAME?


9.8 #NAME?


Any ideas?!

It seems to work if I have understood you correct.

Attached Files

RoundingProblem.xlsx (9.0 KB, 8 views)