怎样使用Excel进行费率计算?答:2.1计算结果单位为元的公式 =IF(A1>10000,(A1-10000)*0.02%*10000+52700,IF(A1>5000,(A1-5000)*0.03%*10000+37700,IF(A1>3000,(A1-3000)*0.06%*10000+25700,IF(A1>1000,(A1-1000)*0.08%*10000+9700,IF(A1>500,(A1-500)*0.09%*10000+5200,IF(A1>100,(A1-100)*0.1%*100...