如何利用Excel公式算出中标金额?答:2.2计算结果单位为万元的公式 =IF(A1>10000,(A1-10000)*0.02%+52700/10000,IF(A1>5000,(A1-5000)*0.03%+37700/10000,IF(A1>3000,(A1-3000)*0.06%+25700/10000,IF(A1>1000,(A1-1000)*0.08%+9700/10000,IF(A1>500,(A1-500)*0.09%+5200/10000,IF(A1>100,(A1-100)*0.1%+...