|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
大写金额感觉不太美观,可以改成这个函数=IF(E12=0,"",IF(AND(ISERR(FIND("拾万零",TEXT(INT(E12),"[dbnum2]"))),ISERR(FIND("拾万元",TEXT(INT(E12),"[dbnum2]")&"元"))),SUBSTITUTE(TEXT(INT(E12),"[DBNum2]"),"拾万","拾万零")&"元",TEXT(INT(E12),"[dbnum2]")&"元"))&IF(INT(E12*10)-INT(E12)*10=0,IF(INT(E12)*(INT(E12*100)-INT(E12*10)*10)=0,"","零"),IF(AND((INT(E12)-INT(E12/10)*10)=0,INT(E12)>0),"零"&TEXT(INT(E12*10)-INT(E12)*10,"[dbnum2]")&"角",TEXT(INT(E12*10)-INT(E12)*10,"[dbnum2]")&"角"))&IF((INT(E12*100)-INT(E12*10)*10)=0,"整",TEXT(INT(E12*100)-INT(E12*10)*10,"[dbnum2]")&"分") |
|