Simone问题补充说明：=IF((A7-5000)<=0,0,IF((A7-5000)>80000,(A7-5000)*45%-10560,IF((A7-5000)>55000,(A7-5000)*35%-5505,IF((A7-5000)>35000,(A7-5000)*30%-2755,IF((A7-5000)>9000,(A7-5000)*25%-1005... =IF((A7-5000)<=0,0,IF((A7-5000)>80000,(A7-5000)*45%-10560,IF((A7-5000)>55000,(A7-5000)*35%-5505,IF((A7-5000)>35000,(A7-5000)*30%-2755,IF((A7-5000)>9000,(A7-5000)*25%-1005,IF((A7-5000)>4500,(A7-5000)*20%-555,IF((A7-5000)>1500,(A7-5000)*10%-105,IF((A7-5000)>0,(A7-5000)*3%,0))))))))这个公式我怎么加入round保留两位小数啊？加入进去没用...=round（IF((A7-5000)<=0,0,IF((A7-5000)>80000,(A7-5000)*45%-10560,IF((A7-5000)>55000,(A7-5000)*35%-5505,IF((A7-5000)>35000,(A7-5000)*30%-2755,IF((A7-5000)>9000,(A7-5000)*25%-1005,IF((A7-5000)>4500,(A7-5000)*20%-555,IF((A7-5000)>1500,(A7-5000)*10%-105,IF((A7-5000)>0,(A7-5000)*3%,0))))))))，2）=（）round（IF((A7-5000)<=0,0,IF((A7-5000)>80000,(A7-5000)*45%-10560,IF((A7-5000)>55000,(A7-5000)*35%-5505,IF((A7-5000)>35000,(A7-5000)*30%-2755,IF((A7-5000)>9000,(A7-5000)*25%-1005,IF((A7-5000)>4500,(A7-5000)*20%-555,IF((A7-5000)>1500,(A7-5000)*10%-105,IF((A7-5000)>0,(A7-5000)*3%,0))))))))，2）这两个方式都没用。 展开
这里那六策唱环牛有个a*100+0.5，注意a*100+0.5=12345.7352,再除以100即是123.457352,%仍或煤送鲜技必尽位被.2f是四舍五入的，纳闹芦因为小数点后第三位是7，所以会进洞带一位弯物。
