如何用EXCEL 计算员工分段提成

2025-01-20 21:05:09
推荐回答(2个)
回答1:

=LOOKUP(A1,{0,1,4,7,10}*10^4,{0,17,19,20,22}%)*A1+3000
是这样的效果吗?

回答2:

=LOOKUP(A29,{0,1,4,7,10}*10^4,{0,17,19,20,22}%*A29-{0,1700,2500,3200,5200})+3000