小數點 進位或捨去 (15008)

C2=INT(B2)+(SUMPRODUCT(N(MOD(B$2:B$21,1)>MOD(B2,1)))<E$2)

另解{=(MOD(B2,1)>LARGE(MOD(B$2:B$21,1),E$2+1))+INT(B2)