=LOOKUP(A1,{0,100,200,300;0,002,003,004})(A1-LOOKUP(A1,{0,100,200,300;0,0,200,300}))+(LOOKUP(A1,{0,200,300;0,4,7}))
设单数为x,提成为y
y=0 (0=<x<=5)
y=100(x-5) (6=<x<=15)
y=1000+150(x-15) (16=<x<=25)
y=2500+200(x-25) (26=<x<=45)
y=6500+300(x-45) (x>=46)
欢迎分享,转载请注明来源:品搜搜测评网