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表格算分段提成公式答:假如业绩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计算公式,计算方式见补充内容,计 ...答:其实真的不是那么简单的答案,因为涉及到累加的问题.算诉讼费的公式:(公式中的A11改为实际价额的单元格即可)=CHOOSE(LOOKUP(A11,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000},{1,2,3,4,5,6,7,8,9,10}),50,50+(A11-10000)*0.025,2300+(A11-100000)*0.02,...