EXCEL中怎样用IF公式计算提成?答:EXCEL中怎样用IF公式计算提成的方法如下:1、D3是数据,2、在E3输入公式:=IF(D3>=24,3.5%,IF(D3>=18,3%,IF(D3>=12,2.5%,IF(D3>=8,2%,IF(D3>=4,1%,0)))3、E列单元格的格式设置成“百分比”,小数位数设置为1。
求EXCEL销售提成阶梯计算公式答:公式为:=SUMPRODUCT(TEXT((A1-{0,5,10,15,20,25}*1000),"0;!0")*{0.05,0.01,0.01,0.01,0.01,0.01})如图所示:
求用Excel公式,计算阶梯式提成答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图:
excel中怎样用函数求提成率?答:公式:=MIN(VLOOKUP(A2,{16,0.3;18,0.8;20,1.5;22,2},2),VLOOKUP(B2,{60,0.3;75,0.8;90,1.5;105,2},2))示例:哦,补充一点,最后结果再除以100,也就是公式为=MIN(VLOOKUP(),VLOOKUP())/100