求阶梯式业绩提成算法公式答:=IF(A2>=40000,A2*40%,IF(A2>=30000,A2*35%,IF(A2>=200000,A2*30%,IF(A2>=10000,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单元格,那么...
excel阶梯提成计算公式答:假设销售额数据是在B2单元格开始的B列,则可以在C2单元格输入公式:=LOOKUP(B2/10^6,{0,3,8,15,30},{6,7,8,9,10}/10^4)复制并下拉,即可得到提成比例。提成额公式为:=B2*LOOKUP(B2/1000000,{0,3,8,15,30},{6,7,8,9,10}/10000)
阶梯提成 公式 EXCEL答:=VLOOKUP(A1,{0,0.01;100,0.02;200,0.03;300,0.04;400,0.05;500,0.06;600,0.07;700,0.08;800,0.09;900,0.1},2,TRUE)假如数据在A1用上面的公式就可以了