使用道具 举报
=100-IF(C2>=1,100,IF(C2>0,50,0))-IF(B2>=2,100,IF(B2>1,50,0))
就是大于等于这里,不清楚题意,可自行更改。
希望可以帮你!D2=IF(B2=2,-100,IF(AND(B2>1,B2<2),-50,))+IF(C2=1,-100,IF(AND(C2<1,C2>0),-50,))+100
下拉!
本版积分规则 发表回复 回帖后跳转到最后一页
小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )
GMT+8, 2024-5-26 15:22 , Processed in 0.329806 second(s), 10 queries , Gzip On, Yac On.
Powered by Discuz! X3.4
Copyright © 2001-2020, Tencent Cloud.