求大神指导这个函数公式哪里有漏洞,为什么我在表格中总是算不出结果...

发布网友 发布时间：2024-09-25 01:31

我来回答

共3个回答

热心网友 时间：2024-09-28 03:43

5000<=D3<=50000表达式错误，应改为AND(5000<=D3,D3<=50000)，另外50000时有交叉，修改如下：
=IF(AND(5000<=D3,D3<=50000),0.075,IF(AND(50000<D3,D3<=100000),0.08,IF(AND(100000<D3,D3<=200000),0.095,0.12)))

热心网友 时间：2024-09-28 03:48

你没表述大于200000的是多少。完整的应该是
=IF(D3<5000,0.12,IF(D3<50000,0.075,IF(D3<100000,0.08,IF(D3<100000,0.08,IF(D3<200000,95,"其他比率")))))

热心网友 时间：2024-09-28 03:46

公式改为 =IF(AND(D3>=5000,D3<=50000),0.075,IF(AND(D3>50000,D3<=100000),0.08,IF(D3>100000,D3<=200000),0.095,0.12)))
AND是一个并列的公式