2024年4月2日发(作者：)

超全的人民币金额大写excel公式

有同学在微信平台提问人民币大写公式怎么写，小编就从

网上搜集了一些，公式很多，也很复杂，有兴趣的同学可

以研究一下，不想研究的就收藏起来备用。

使用方法很简单，把下面公式中的A2换成你表中数字所在

单元格地址即可。

1

=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A2)),"[>0][dbnum2]G/

通用格式元;[<0]负[dbnum2]G/通用格式

元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"

整",)),"零角",IF(ABS(A2)<1,,"零")),"零分","整")

2 =SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负

")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]G/通用格式

元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"

整",)),"零角",IF(ABS(A2)<1,,"零")),"零分","整")

3

=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负

")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式

元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"

整",)),"零角",IF(ABS(A2)<1,,"零")),"零分","整")

4 =SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负

")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]G/通用格式

元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"

整",)),"零角",IF(ABS(A2)<1,,"零")),"零分","整")

5 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负

")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]")&TEXT(RIGHT(FIXED(A2),2),"

[dbnum2]元0角0分;;元"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零

")),"零元",),"零分","整")

6 =SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负

")&IF(ABS(A2)+0.5%<1,,TEXT(INT(ABS(A2)+0.5%),"[dbnum2]")&"元