Question

如何把小写金额转换成英文大写？

Answer 1

A1单元格输入数据，在B1单元格输入公式即可

1、=IF(A1<0,"金额为负无效",

2、(IF(OR(A1=0,A1=""),"(人民币)零元",

3、IF(A1<1,"(人民币)",

4、TEXT(INT(A1),"[dbnum2](人民币)G/通用格式")&"元"))))&

5、IF((INT(A1*10)-INT(A1)*10)=0,

6、IF(INT(A1*100)-INT(A1*10)*10=0,"","零"),

7、(TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角"))

8、&IF((INT(A1*100)-INT(A1*10)*10)=0,

9、"整",TEXT((INT(A1*100)-INT(A1*10)*10),"[dbnum2]")&"分")