Excel大写金额

最新推荐文章于 2025-09-21 15:22:51 发布

原创最新推荐文章于 2025-09-21 15:22:51 发布 · 404 阅读

0 ·

CC 4.0 BY-SA版权

其他专栏收录该内容

3 篇文章

订阅专栏

方法一：

=IF((A9-INT(A9))=0,TEXT(A9,"[DBNUM2]")&"元整",IF(INT(A9*10)-A9*10=0,TEXT(INT(A9),"[DBNUM2]")&"元"&TEXT((INT(A9*10)-INT(A9)*10),"[DBNUM2]")&"角整",TEXT(INT(A9),"[DBNUM2]")&"元"&IF(INT(A9*10)-INT(A9)*10=0,"零",TEXT(INT(A9*10)-INT(A9)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A9,1),"[DBNUM2]")&"分"))

方法二：

=IF(INT(A9)*100=A9*100,TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元整",IF(INT(A9*10)=A9*10,TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元"&TEXT(A9*10-INT(A9)*10,"[$-0804][DBNum2]G/通用格式")&"角整",TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元"&IF(INT(A9*10)=INT(A9)*10,"零",TEXT(RIGHT(INT(A9*10)),"[$-0804][DBNum2]G/通用格式")&"角")&TEXT(RIGHT(A9*100),"[$-0804][DBNum2]G/通用格式")&"分"))