业务员工资分段抽成的函数计算公式.假如本月业绩小于基数*0.85,则抽成为零.若大于基数*0.85,小于基数*1,则抽成为0.002*本与业绩.若本月业绩大于基数*1,小于基数*1.2,则抽成为0.003*本月业绩.若

Question

业务员工资分段抽成的函数计算公式.
假如本月业绩小于基数*0.85,则抽成为零.若大于基数*0.85,小于基数*1,则抽成为0.002*本与业绩.若本月业绩大于基数*1,小于基数*1.2,则抽成为0.003*本月业绩.若本月业绩大于基数*1.2,则抽成为0.005*本月业绩.设基数为D2,本月业绩为H2.

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)))