怎么把阿拉伯数字金额变成大写金额
答案:1 悬赏:60 手机版
解决时间 2021-02-20 23:29
- 提问者网友：轮囘Li巡影
- 2021-02-20 17:55
怎么把阿拉伯数字金额变成大写金额
最佳答案
- 五星知识达人网友：你哪知我潦倒为你
- 2021-02-20 18:06
所以就想了利用Excel函数公式自动转化成人民币大写金额。现在和大家分享一样：=IF(B9<0,"负","") &IF(ROUND(B9,2)=0,"零元整",IF(ROUND(ABS(B9),2)>=1,TEXT(INT(ROUND(ABS(B9),2)),"[DBNum2]")&"元","")&IF(RIGHt(TEXT(B9,".00"),2)*1=0,"整",IF(RIGHt(TEXT(B9,".00"),4)*1>=1,IF(RIGHt(TEXT(B9,".00"),2)*1>9,"","零"),IF(ROUND(ABS(B9),2)>=1,"零",""))&IF(RIGHt(TEXT(B9,".00"),2)*1>9,TEXT(LEFt(RIGHt(TEXT(B9,".00"),2)),"[DBNum2]")&"角","")&IF(RIGHt(TEXT(B9,".00"))*1>0,TEXT(RIGHt(TEXT(B9,".00")),"[DBNum2]")&"分","整")))注：B9是填写的小写数字。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯