excel怎么计算工资提成,求个公式,谢谢啦答:=SUMPRODUCT(TEXT(A1-{0,8,15,25,35,45,55}*1000,"0;!0")*{1,1,1,2,1,1,1}%)
如何用Excel函数计算提成?答:度友,条件辅助列,用公式可以达到目的,如图 具体公式为:=D2*LOOKUP(C2,{"A","B","C","D","E"},{0.1,0.15,0.2,0.3,0.35}),
excel业绩提成公式答:你这个类似个税,我想一下。10000以下的是20%吗?如果业绩在F3,公式:=ROUND(MAX(F3*{0.2,0.25,0.3,0.35,0.4,0.45,0.5}-{0,500,1500,2750,4250,6000,8500},0),2)