問題已解決
怎樣用函數(shù)把借貸方向表示出來
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
是的謝謝老師
2017 05/30 22:39
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84785013 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2017 05/30 23:02
老師這個怎么解決
![](https://pic1.acc5.cn/009/24/64/10_avatar_middle.jpg?t=1651203235)
李愛文老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2017 05/30 22:35
想表達是期初余額的“借貸方向”嗎?你提問題我?guī)湍阌煤瘮?shù)解決
![](https://pic1.acc5.cn/009/24/64/10_avatar_middle.jpg?t=1651203235)
李愛文老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2017 05/30 23:09
=IF(AND(LEFT(C2,1)=1,FIND("折舊",D2)<>0),"貸",IF(AND(LEFT(C2,1)=1,FIND("準備",D2)<>0),"貸",IF(LEFT(C2,1)="1","借",IF(OR(LEFT(C2,1)="2",LEFT(C2,1)="3"),"貸","平"))))
![](/wenda/img/newWd/sysp_btn_eye.png)