=ROUND(IF(INT(RIGHT(A2,1))>=5,A2-0.00005,A2+0.00005),4)
或
=IF(INT(RIGHT(A2,1))>=5,ROUNDDOWN(A2,4),ROUNDUP(A2,4))
原值 | 四入五舍(保留四位小數) |
29.22224 | 29.2223 |
29.77775 | 29.7777 |
=ROUND(IF(INT(RIGHT(A2,1))>=5,A2-0.00005,A2+0.00005),4)
或
=IF(INT(RIGHT(A2,1))>=5,ROUNDDOWN(A2,4),ROUNDUP(A2,4))
原值 | 四入五舍(保留四位小數) |
29.22224 | 29.2223 |
29.77775 | 29.7777 |