怎么用Excel将小写金额转换成人民币的大写金额

=IF(B1<0,"金额为负无效",
(IF(OR(B1=0,B1=""),"(人民币)零元",
IF(B1<1,"(人民币)",
TEXT(INT(B1),"[dbnum2](人民币)G/通用格式")&"元"))))&
IF(
(INT(B1*10)-INT(B1)*10)=0,
IF(INT(B1*100)-INT(B1*10)*10=0,"","零"),
(TEXT(INT(B1*10)-INT(B1)*10,"[dbnum2]")&"角"))
&IF(
(INT(B1*100)-INT(B1*10)*10)=0,
"整",
TEXT((INT(B1*100)-INT(B1*10)*10),"[dbnum2]")&"分")
参考：http://jingyan.baidu.com/article/d2b1d1024cb3f65c7f37d46b.html

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/vxxj7ervvjjvvfe23y.html