发布时间：2019-08-01 00:31:39
大神帮忙看看！ 为什么结果显示为FALSE，而不是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,""))))))))
你少条件了
要么是
=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,""))))))),"这里")