正在阅读:excel大写金额公式excel大写金额公式

2019-09-10 14:30 出处:其他 作者:佚名 责任编辑:gaofuda

  excel大写金额公式是【=IF(MOD(A2,1)=0,TEXT(INT(A2),"[DBNUM2]")&"元"&"整",TEXT(INT(A2),"[DBNUM2]")&"元"&TEXT(MID(A2,LEN(INT(A2))+2,1),"[DBNUM2]D角")&TEXT(MID(A2,LEN(INT(A2))+3,1),"[DBNUM2]D分"))】,具体介绍如下:

  1、以A行为输入阿拉伯数字,B行为大写数字,在A1和B1分别填入对应的项目名称;

  2、在B2行录入:=IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"分","整");

  3、还可以在B2输入:=IF(MOD(A2,1)=0,TEXT(INT(A2),"[DBNUM2]")&"元"&"整",TEXT(INT(A2),"[DBNUM2]")&"元"&TEXT(MID(A2,LEN(INT(A2))+2,1),"[DBNUM2]D角")&TEXT(MID(A2,LEN(INT(A2))+3,1),"[DBNUM2]D分"));

  4、您在A2输入阿拉伯数字,在B2就会自动显示大写金额。

相关文章

关注我们

最新资讯离线随时看 聊天吐槽赢奖品