=100000,0.1,IF(AND(SUM(D15:E15)>=65000,SUM(D15:E15)<=99999),0.08,IF(AND(SUM(D15:E15)>=45000,SUM(D15:E15)<=6" />

IF结果为FALSE

用户提问 |浏览1222次
收藏|2019/06/22 19:29

满意回答

2019/06/22 20:02

你少条件了要么是=IF(D15>=1500,"这个",IF(SUM(D15:E15)>=100000,0.1,IF(AND(SUM(D15:E15)>=65000,SUM(D15:E15)<=99999),0.08,IF(AND(SUM(D15:E15)>=45000,SUM(D15:E15)<=64999),0.06,IF(AND(SUM(D15:E15)>=25000,SUM(D15:E15)<=44999),0.04,IF(AND(SUM(D15:E15)>=15000,SUM(D15:E15)<=24999),0.03,IF(AND(SUM(D15:E15)>=1,SUM(D15:E15)<=14999),0.02,IF(AND(SUM(D15:E15)<=0),0,""))))))))要么用=IF(D15>=1500,IF(SUM(D15:E15)>=100000,0.1,IF(AND(SUM(D15:E15)>=65000,SUM(D15:E15)<=99999),0.08,IF(AND(SUM(D15:E15)>=45000,SUM(D15:E15)<=64999),0.06,IF(AND(SUM(D15:E15)>=25000,SUM(D15:E15)<=44999),0.04,IF(AND(SUM(D15:E15)>=15000,SUM(D15:E15)<=24999),0.03,IF(AND(SUM(D15:E15)>=1,SUM(D15:E15)<=14999),0.02,IF(AND(SUM(D15:E15)<=0),0,""))))))),"这里")
匿名

其他回答(0)
0人关注该问题
+1

 加载中...