如果数值小于4200,等于0,数值大于等于4200,小于4400,等于0.05,数值大于等于4400,小于4600,等于0.07,数值大于等于4600,等于0.09
老师请问excel函数怎么设?
![](/wenda/images/newWd/search.png)
问题已解决
所属话题:
#Excel#
![](http://member.chinaacc.com/homes/resources/images/home/avatar/8.jpg)
84784968 | 提问时间:2019 12/12 14:28
你好,可以用这个公式,如图所示
=VLOOKUP(A8,{0,0;4200,0.05;4400,0.07;4600,0.09},2)
![](https://al3.acc5.com/9133065_5df1df4cd9947.png)
2019 12/12 14:34
相关问答
查看更多最新问答
查看更多