求阶梯式业绩提成算法公式答:A2*25%,IF(A2>=5000,A2*20%,“”)))假设销售额在A1单元格,则公式为:=IF(A1<15000,A1*0.03,IF(A1<22500,750+(A1-15000)*0.08,1350+(A1-22500)*0.1))如果业绩为30万,在A2单元格,那么输入=SUM(TEXT(A2-{5,10,16,25},"0;!0")*{0.025,0.03,0.04,0.05})。
excel分段计算的函数及公式答:经过层层嵌套,最终公式为:=IF(B6<=10000,B6*2%,IF(B6<=30000,200+(B6-10000)*3%,IF(B6<=50000,800+(B6-30000)*4%,IF(B6<=80000,1600+(B6-50000)*6%,3400+(B6-80000)*8%))),再向上回拖,C2的公式为:=IF(B2<=10000,B2*2%,IF(B2<=30000,200+(B2-10000)*3%,IF(B2<=50000...