IF结果为FALSE

更新时间：2019-06-24 04:55:40 169次访问

大神帮忙看看！    为什么结果显示为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,""))))))),"这里")