excel公式实现分段取费,自动生成一个值的累计取费金额。答:=IF(A1<100,2.4%,IF(AND(A1>100,A1<200),1.8%,IF(AND(A1>200,A1<1000),1.2%,IF(AND(A1>1000,A1<2000),0.75%,IF(AND(A1>2000,A1<5000),0.16%,IF(AND(A1>5000,A1<10000),0.08%,IF(A1>10000,0.01%,"")))根据实际自己修改比列 ...
求excel分段计算公式,谢谢大侠!答:公式为:=SUMPRODUCT(TEXT(A1-{0,60,80,100,150},"0.00;!0")*{0,5,1,1,1})如图所示: