問題已解決
老師,我想咨詢算運費,虧噸在0.1,公司承擔,高于0.1按照當日煤價從運費扣除,實發(fā)運費的公式怎么設置
![](https://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
你好,你這個問題并沒有描述出來計算規(guī)則啊,高于0.1的時候,扣多少,怎么扣?
2019 07/16 15:59
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/16 16:19
可以發(fā)表格嗎
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel劉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/16 16:21
帶行號、列標截圖就可以了。關鍵是你得描述出來怎么計算,比如誰加誰,誰乘誰,這些你自己得說
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/16 16:23
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/16 16:30
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/16 16:31
可以看清嗎,主要需要取值
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel劉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/16 16:39
你好,可以參照圖中的公式
![](http://member.chinaacc.com/homes/resources/images/home/avatar/0.jpg)
84784950 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 07/16 17:25
保留兩位小數(shù),也是這樣嗎
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel劉老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 07/16 17:35
四舍五入函數(shù)是round函數(shù),=round(原來的公式,2)
![](/wenda/img/newWd/sysp_btn_eye.png)