求excel分段累进计息公式答:=F(C2<=7,1,IF(C2<91,1.2%,IF(C2<121,1.3%,IF(C2<151,1.4%,IF(C2<181,1.5%,2.4%)))*B2
excel工资分段计提函数 分段。。。提成。。每个区间单算答:楼主,你的意思是不是这样:如果业绩小于3500,则0-2500按5%提取,2501-3500按15%提取 如果业绩大于等于3500,则0-4000按15%提取,4001-5500按18%提取,5501-7000按21%提取,7001以上按25%提取,是这意思吗?如果是,公式如下:假设总业绩在D1,在E1写公式:=3*IF(D1<3500,MAX(D1*{5,15}%-{0,250}...
求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....