你少条件了要么是=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,""))))))),"这里")