怎样在单元格里自动显示人民币大写金额

=IF(ISNUMBER(A3),IF(INT(A3),TEXT(INT(A3),[dbnum2])&元,)&IF(INT(A310)-INT(A3)10,TEXT(INT(A310)-INT(A3)10,[dbnum2])&角,IF(INT(A3)=A3,,IF(A30.1,,零)))&IF(ROUND((A3)100-INT(A310)10,),TEXT(ROUND(A3100-INT(A310)10,),[dbnum2])&分,整),)

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

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