更新时间2018-11-28 07:17:58
≤2W,45%, 扣10%费用之后提成45%,【X*(1-10%)*45%】
2W≤X≤5W, 扣10%费用之后提成47%
5W≤X≤10W,扣10%费用之后提成50%
10W≤X≤20, 扣10%费用之后提成58%
≥20W , 扣10%费用之后提成60%,
求大神指教,这个怎么在电子表格中用函数计算啊?
精炼公式(94字符):
=(A1*LOOKUP(A1,{0,2,5,10,20},{45,47,50,58,60})%-LOOKUP(A1,{0,2,5,10,20},{0,4,19,99,139})%)*0.9
传统的条件判断公式(174字符):
=0.9*(IF(A1<=2,A1*0.45,2*0.45)
+IF(A1>2,IF(A1<=5,(A1-2)*0.47,3*0.47))
+IF(A1>5,IF(A1<=10,(A1-5)*0.5,5*0.5))
+IF(A1>10,IF(A1<=20,(A1-10)*0.58,10*0.58))
+IF(A1>20,(A1-20)*0.6))