EXCEL阶梯提成?答:=IF(A1<=3000,0,IF(A1<=10000,0.03%,IF(A1<=30000,0.05%,0.08%)))公式意思是:如果A1<=3000,那么返回0,如果A1<=10000,那么返回0.03%,如果A1<=30000,那么返回0.05%,否则(不满足前面所有条件时),返回0.08 或者公式为:=IF(A1>30000,0.08%,IF(A1>10000,0.05%,IF(A1>3...
求阶梯式业绩提成算法公式答:=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)...