C6=N(B6+10*(B6=0)-B5=1)
D6=N(B5+10*(B5=0)-B6=1)
E6=N(MOD(B5,2)+MOD(B6,2)=2)
F6=N((B5<5)+(B6<5)=2)
使用道具 举报
谢谢qinqh_yl老师!
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-6-15 04:46 , Processed in 1.049161 second(s), 6 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.