怎样在exceL表格中设置输入小写金额的同时在另一个单元格中自动生成大写金额?
![](/wenda/images/newWd/search.png)
问题已解决
所属话题:
#财务软件#
![](http://member.chinaacc.com/homes/resources/images/home/avatar/3.jpg)
84785003 | 提问时间:2018 09/27 13:42
您好,输入以下函数,=IF(J60<0,负,)&IF(ABS(J60)>1,TEXT(TRUNC(ABS(ROUND(J60,2))),[DBNum2])&元,)&IF(ISERR(FIND(.,ROUND(J60,2))),,TEXT(RIGHT(TRUNC(ROUND(J60,2)*10)),[DBNum2]))&IF(ISERR(FIND(.0,TEXT(J60,0.00))),角,)&IF(LEFT(RIGHT(ROUND(J60,2),3))=.,TEXT(RIGHT(ROUND(J60,2)),[DBNum2])&分,整)注意需要将此函数里的J60改为小写金额所在的单元格。
2018 09/27 13:43
相关问答
查看更多最新问答
查看更多