本帖最后由 hq0802 于 2011-7-10 22:34 编辑
想把小写金额变为大写金额吗,一个公式就解决了
=IF(A1<0,"负","")&IF(TRUNC(ROUND(A1,2))=0,"",TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元")&IF(ISERR(FIND(".",ROUND(A1,2))),"",IF(AND(LEFT(TRUNC(ROUND(A1,2)))="0",RIGHT(TRUNC(ROUND(A1,2)*10))="0"),,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]")&"分","整")
注意,这可只是一个公式,可别写分开了。
|