A:万元
2<=A<3,工资提成2.5%*A;
3<=A<5,工资提成1.2%*(A-3)+750;
5<=A<8,工资提成1.1%*(A-5)+990;
8<=A,工资提成1.%*(A-8)+1320
LOOKUP(A,{2,3,5,8},{25000,12000,11000,100000})%*(A-LOOKUP(A,{2,3,5,8},{0,3,5,8}))+LOOKUP(A,{2,3,5,8},{0,750,990,1320})
刚设的那个公式超过10万就不对了,超过20万就更不对了
本帖最后由 zjdh 于 2016-7-2 16:36 编辑
=(LOOKUP(A2,{0,2,3,5,8},{0,2.5,1.2,1.1,1})*(A2-LOOKUP(A2,{0,3,5,8},{0,3,5,8})))*100+LOOKUP(A2,{0,3,5,8},{0,750,990,1320})
Book1.rar
(6.95 KB, 下载次数: 3)
|