在Excel中如何设置分条件及分段计算的公式答:=IF(AND(OR(E3="散居五保",E3="城镇三无"),K3-L3<=3000),MIN(K3-L3,3000),IF(AND(OR(E3="农村低保",E3="城镇低保"),(K3-L3)<=1000),(K3-L3)*0.5,IF(AND(OR(E3="农村低保",E3="城镇低保"),(K3-L3)<=2000),500+(K3-L3-1000)*0.3,IF(AND(OR(E3="农村低保",E3...
Excel中分段计算分数怎么设置公式?答:假设考核指标在A1单元格,年初指标在C1单元格。公式=IF(AND(A1>0,A1<=1%),15,IF(AND(A1>1%,A1<=3%),MIN(13+13*A1,14),IF(AND(A1>3%,A1<=5%),MIN(11+11*A1,12),IF(A1>5%,IF(A1-C1>0,0,MIN(9+((C1-A1)/0.1%)*0.1,12)),"")))...
EXCEL分段式计算业绩提成公式答:例如:提成规则:3W及以下 3% 3W-4W 6% 4W-6W 8% 6W-8W 10% 8W及以上 12% 则公式为 =LOOKUP(A2,{0,3,4,6,8}*10^4+1,A2*{0.03,0.06,0.08,0.1,0.12}-{0,900,1700,2900,4500})