Excel条件格式公式设置問題,寻找特定尾数

excel

1个回答

写回答

13529597442

2025-12-20 03:23

+ 关注

条件格式

=AND(A1,OR(RIGHT(TEXT(A1,0.000),2)/100=0,RIGHT(TEXT(A1,0.000),2)/100=0.1,RIGHT(TEXT(A1,0.000),2)/100=0.25,RIGHT(TEXT(A1,0.000),2)/100=0.5,RIGHT(TEXT(A1,0.000),2)/100=0.75))

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号