提成式工资EXCEL计算公式 类似个人所得税征收方式 分档 阶梯式 加急...答:假设A1销售额B1底薪,=MAX((A1-100000),0)*0.2+MAX(MIN(A1-80000,20000),0)*0.15+MAX(MIN(A1-60000,20000),0)*0.08+MIN(A1,60000)*0.02+MIN(A1/60000,1)*B1 因为工资结算时是以分为单位,所以严谨些应是 =ROUND(MAX((A1-100000),0)*0.2,2)+ROUND(MAX(MIN(A1-80000,20000)...
求用Excel公式,计算阶梯式提成答:建议参照如下:在J4单元格中输入公式:=IF(I4<1000,"小微",IF(AND(I4>=1000,I4<5000),"三级",IF(AND(I4>=5000,I4<10000),"二级",IF(AND(I4>=10000,I4<50000),"一级","特级")))如图: