请问用什么公式使数字金额，转换为大写金额？

冰岛菇凉 追问

2019-12-29 08:00

是的

老江老师 解答

2019-12-29 10:01

试一下，这个函数呢
=SUBSTITUTE(SUBSTITUTE(IF(A1<0,负,)&TEXT(TRUNC(ABS(ROUND(A1,2))),[DBNum2])&元&IF(ISERR(FIND(.,ROUND(A1,2))),,TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),[DBNum2]))&IF(ISERR(FIND(.0,TEXT(A1,0.00))),角,)&IF(LEFT(RIGHT(ROUND(A1,2),3))=.,TEXT(RIGHT(ROUND(A1,2)),[DBNum2])&分,IF(ROUND(A1,2)=0,,整)),零元零,),零元,零)