求大神指导这个函数公式哪里有漏洞,为什么我在表格中总是算不出结果...
发布网友
发布时间：2024-09-25 01:31
共3个回答
热心网友
时间：1天前
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)))
热心网友
时间：1天前
你没表述大于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,"其他比率")))))
热心网友
时间：1天前
公式改为 =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是一个并列的公式
