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]")&"分")