请问在excel表格中如何取绝对值后小数后面的数字与0.5比大小,若大于0.5则减1,若小于0.5则减0.5即A1=10 ,B1=3.3 则C1=10-3.5=6.5若A1=10 ,B1= -3.3 则C1=10-3.5=6.5若A1=10 ,B1= 3.8 则C1=10-4.0=6.0若A1=10 ,B1= -3.8 则C1=1

Question

请问在excel表格中如何取绝对值后小数后面的数字与0.5比大小,若大于0.5则减1,若小于0.5则减0.5
即A1=10 ,B1=3.3 则C1=10-3.5=6.5
若A1=10 ,B1= -3.3 则C1=10-3.5=6.5
若A1=10 ,B1= 3.8 则C1=10-4.0=6.0
若A1=10 ,B1= -3.8 则C1=10-4.0=6.0,请问如何编辑?

Answer 1

C1=IF(ABS(B1)-INT(ABS(B1))>0.5,A1-ABS(ROUND(B1,0)),(A1-ABS(ROUND(B1,0))-0.5))