业绩提成区间计算EXCEL如何运用函数?答:公式为:=LOOKUP(A1,{0,10,15,25,35,50}*1000,{0.08,0.12,0.15,0.18,0.22,0.3})*A1 如图所示:
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)...