EXCEL自动进位,小数点后面的数达到12,就自动进一位,怎么处理?谢谢

excel

1个回答

写回答

tuzi4747

2025-10-04 18:20

+ 关注

=IF(A1=,,IF(A1=0,0,IF(RIGHT(A1,LEN(A1)-FIND(.,A1))=12,LEFT(A1,FIND(.,A1)-1)+1,A1)))如果值都是要整数用下面这个=IF(A1=,,IF(A1=0,0,IF(RIGHT(A1,LEN(A1)-FIND(.,A1))=12,LEFT(A1,FIND(.,A1)-1)+1,INT(A1))))

=INT(A1+0.88)

举报有用(4分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号