Question

业务员工资分段抽成的函数计算公式.

Answer 1

=if(h2>=d2*1.2,h2*0.005,if(h2>=d2,h2*0.003,if(h2>=d2*0.85,h2*0.002,0)))