excel区间业绩提点计算公式,制作工资表格,需要利用分段提成进行计算...答:=IF(A1>300000,19550+(A1-300000)*0.09,IF(A1>200000,11550+(A1-200000)*0.08,IF(A1>100000,4550+(A1-100000)*0.07,IF(A1>75000,3050+(A1-75000)*0.06,IF(A1>55000,1950+(A1-55000)*0.055,IF(A1>35000,1050+(A1-35000)*0.045,IF(A1>0,A1*0.03)))公式写的我好无聊啊...
关于如何用EXCEL公式计算提成? 如果业绩大于20万提成16%;如果业绩15-2...答:好长的公式……在空白单元格输入公式:=IF(P3>=30000,IF(P3>=200000,A3*16%,IF(P3>=150000,A3*15.5%,IF(P3>=120000,A3*14.5%,IF(P3>=100000,A3*14%,IF(P3>80000,A3*13.5%,IF(P3>=60000,A3*13%,IF(P3>=40000,A3*2.2%,A3*2%))),0)...