excel 分段函数公式答:=LOOKUP(A1,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000},{50,50,2300,4300.88,13800,22800,46800,81800,141800})+(A1-LOOKUP(A1,{0,10000,100000,200000,500000,1000000,2000000,5000000,10000000,20000000}))*LOOKUP(A1,{0,10000,100000,200000,500000,1000000,...
excel分段函数公式?答:可以一段段拆开算了再加起来,假设数据在A1:A100中,写的是类似500000的真正数字,B1中输入 =MAX(500,MIN(A1,500000)*0.2%)+MEDIAN(A1-500000,0,500000)*0.15%+MEDIAN(A1-1000000,0,4000000)*10%%+MEDIAN(A1-5000000,0,15000000)*5%%+MEDIAN(A1-20000000,0,30000000)*3%%+MAX(0,A1-...