主题：如何设置销售提成递增函数公式？

      当销售员月销售总额小于100万元时，而且“销售成本-数量”大于0，其提成比例为1.5‰；大于等于100万且小于150万无时，其提成比例为1.5‰；大于等于150万以上时其提成比例为2.5‰，要求销售提成随销售员的销售额的增加而变化。如果销售人员比较少的情况可以按最笨办法设置也能达要求，可销售人员比较落多时，设置就很繁锁而且运行速度就非常慢，如果能用变量[%销售员%]来替代销售员姓名，那么就简洁多了，但我反复试验都未通过，于是请各位前辈老师给予指教。

      这是我用最笨的办法设置的公式：

If(SumFor("销售统计","销售收入_销售额","销售员"," = ","何华庚")<=1000000  And [销售成本_数量] > 0 And [销售员] ="何庚" ,[销售收入_销售额] * 0.0015,If(SumFor("销售统计","销售收入_销售额","销售员"," = ","何庚") >=1000000 And SumFor("销售统计","销售收入_销售额","销售员"," = ","何庚") <= 1500000 And [销售成本_数量] > 0 And [销售员] ="何庚" ,[销售收入_销售额] * 0.002,If(SumFor("销售统计","销售收入_销售额","销售员"," = ","何庚") >=1500000 And [销售成本_数量] > 0 And [销售员] ="何庚" ,[销售收入_销售额] * 0.0025,If(SumFor("销售统计","销售收入_销售额","销售员"," = ","黄荣")<=1000000  And [销售成本_数量] > 0 And [销售员] ="黄荣" ,[销售收入_销售额] * 0.0015,If(SumFor("销售统计","销售收入_销售额","销售员"," = ","黄金荣") >=1000000 And SumFor("销售统计","销售收入_销售额","销售员"," = ","黄荣") <=1500000 And [销售成本_数量] > 0 And [销售员] ="黄荣" ,[销售收入_销售额] * 0.002,If(SumFor("销售统计","销售收入_销售额","销售员"," = ","黄荣") >=1500000 And [销售成本_数量] > 0 And [销售员] ="黄荣" ,[销售收入_销售额] * 0.0025,""))))))

      上述销售提成递增函数公式可设置成下列形式，这样可解决多业务员的提成随销售量增加而递增问题，是一个十分实用的计效工资计算的函数公式。

 If(SumFor("销售统计","销售收入_销售额","销售员","=",[销售员],"销售成本_数量","> ","0.00")<1000000 ,[销售收入_销售额]*0.0015,If(SumFor("销售统计","销售收入_销售额","销售员","=",[销售员],"销售成本_数量",">","0.00")>=1000000 And SumFor("销售统计","销售收入_销售额","销售员","=",[销售员],"销售成本_数量",">","0.00")<1500000 ,[销售收入_销售额] * 0.002,If(SumFor("销售统计","销售收入_销售额","销售员","=",[销售员],"销售成本_数量",">","0.00")>1500000 ,[销售收入_销售额] * 0.0025,"")))