公式这样
=IF(AND(J5<6000,0.05))+IF(AND(J5>=6000,J5<9000),0.06)+IF(AND(J5>=9000,J5<12000),0.07)+IF(AND(J5>=12000,J5<15000),0.08)+IF(AND(J5>=15000,J5<18000),0.09)+IF(AND(J5>=18000,J5<21000),0.1)+IF(AND(J5>=21000,J5<30000),0.11)+IF(AND(J5>=30000,J5<40000),0.12)+IF(AND(J5>=40000,J5<50000),0.15)+IF(AND(J5>=50000,0.18))
如图,一个区间
J5<6000,K5就显示5%;
J5﹥=6000,K5就显示6%
以此类推
求告知公式哪有问题,或者应该怎么做公式
对了,是这样的,谢谢了,刚才好像也试过这种,不知道哪里没弄好,又不对,现在对了,非常感谢
追答不用谢
本回答被提问者采纳这个公式也可以,好像还更方面,不过刚已经采纳了其他的,还是谢谢哦