Excel公式:如何设置阶梯提成的算法公式答:=SUMPRODUCT(TEXT(C10-{0,1000,2000,2000,3000,2000},"0;\0")*{0,0.06,0.07,0.08,0.1,0.15})下面的:=MEDIAN(0,C16/C15,1)
求excel表格算分段提成公式答:假如业绩X在A1单元格,分段提成公式(保留2位小数)=ROUND(IF(A1<=10000,0,IF(AND(A1>10000,A1<=20000),10000*0+(A1-10000)*0.07,IF(AND(A1>20000,A1<=30000),10000*0+10000*0.07+(A1-20000)*0.08,IF(AND(A1>30000,A1<=40000),10000*0+10000*0.07+10000*0.08+(A1-30000)*0....