我想用EXCEL表格,做个提成计算器

2025-04-16 03:26:08
推荐回答(3个)
回答1:

B1公式:
=LOOKUP(A1,{0,120000,160000,200000,260000},{"","1.2%","2%","3%","4.5%"})

回答2:

=lookup(a1/10000,{0,12,16,20,26},{0,1.2,2,3,4.5})*A1/100

回答3:

=Lookup(a1/10000,{0,0;12,1.2;16,2;20,3;26,4.5})%*a1