Excel 想在格中显示人民币大写圆整，公式是什么？

答案:5 悬赏:60 手机版

解决时间 2021-11-30 23:12

提问者网友：蓝莓格格巫
2021-11-30 09:08

最佳答案

五星知识达人网友：怀裏藏嬌
2021-11-30 10:19

C6单元格输入
="人民币："&IF(TRIm(C6)="","",IF(C6=0,"","人民币"&IF(C6<0,"负",)&IF(INT(C6),TEXT(INT(ABS(C6)),"[dbnum2]")&"圆",)&IF(INT(ABS(C6)*10)-INT(ABS(C6))*10,TEXT(INT(ABS(C6)*10)-INT(ABS(C6))*10,"[dbnum2]")&"角",IF(INT(ABS(C6))=ABS(C6),,IF(ABS(C6)<0.1,,"零")))&IF(ROUND(ABS(C6)*100-INT(ABS(C6)*10)*10,),TEXT(ROUND(ABS(C6)*100-INT(ABS(C6)*10)*10,),"[dbnum2]")&"分","整")))

全部回答

1楼网友：躲不过心动
2021-11-30 13:56

这是前面没有美元符号的公式看你的能不能去掉美元符号=SUBSTITUTE(SUBSTITUTE(IF(C8<0,"负","")&TEXT(TRUNC(ABS(ROUND(C8,2))),"[DBNum2]")&"元 "&IF(ISERR(FIND(".",ROUND(C8,2))),"",TEXT(RIGHt(TRUNC(ROUND(C8,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(C8,"0.00"))),"角 ","")&IF(LEFt(RIGHt(ROUND(C8,2),3))=".",TEXT(RIGHt(ROUND(C8,2)),"[DBNum2]")&"分",IF(ROUND(C8,2)=0,"","整")),"零元零",""),"零元","")

2楼网友：十年萤火照君眠
2021-11-30 12:40

C6公式：
=TEXT(B6*100,"人民币[dbnum2]0万0仟0佰0拾0元0角0分整")

3楼网友：动情书生
2021-11-30 11:38

C6="人民币"&TEXT(RIGHt(B6,LEN(B6)-1),"[dbnum2]")&"圆整"

4楼网友：零点过十分
2021-11-30 10:54

参考公式：
=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(B6)),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHt(FIXED(B6),2),"元[dbnum2]0角0分;;"&IF(ABS(B6)>1%,"元整",)),"零角",IF(ABS(B6)<1,,"零")),"零分","整")
如果B6是输入的文本￥，计算可能会出错。

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息