求excel表格算分段提成公式答:假如业绩X在A1单元格,分段提成公式(保留2位小数)=ROUND(IF(A1<=10000,0,IF(AND(A1>10000,A1<=20000),10000*0+(A1-10000)*0.07,IF(AND(A1>20000,A1<=30000),10000*0+10000*0.07+(A1-20000)*0.08,IF(AND(A1>30000,A1<=40000),10000*0+10000*0.07+10000*0.08+(A1-30000)*0....
Excel公式:如何设置阶梯提成的算法公式答:=SUMPRODUCT(TEXT(C10-{0,1000,2000,2000,3000,2000},"0;\0")*{0,0.06,0.07,0.08,0.1,0.15})下面的:=MEDIAN(0,C16/C15,1)
在excel中计算阶段提成课时费,例如,学生数9个,当月课时数145,就按照...答:1、你的课时费(课时费=75*20+80*30+15*(145-130))应该是写错了吧,应该是课时费=75*20+80*30+85*(145-130)2、按下图建表 3、在C9单元格输入”=IF(C8>100,20,C8-80)*(C8>80)*INDEX($B$2:$F$5,1,LOOKUP(C7,{5,6,8,10,15;1,2,3,4,5}))+IF(C8>130,30,C8-100...
Excel如何根据不同级别的不同完成率来计算提成?答:1.3 1.5 是倍数吧!G10=LOOKUP(F10,$A$3:$A$6,$B$3:$B$6)*IF(C10="店员",1,(INDEX($C$3:$D$6,LOOKUP(F10,$A$3:$A$6,ROW(A$1:A$4)),IF(C10="店长",2,IF(C10="店助",1)))