Question

在Excel 如何实现把阿拉伯数字变成大写人民币金额？

Answer 1

教你一招，因为工作经常要用到小写数字和人民币大写金额。所以就想了利用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是填写的小写数字。如是其它单元格，则把B9改成你要输入的单元格即可。