excel数字金额自动变大写金额
=IF(ROUND(A2,2)0,\"无效数值\",IF(ROUND(A2,2)=0,\"零\",IF(ROUND(A2,2)1,\"\",TEXT(INT(ROUND(A2,2)),\"[dbnum2]\")0,\"无效数值\",IF(ROUND(A1,2)=0,\"零\",IF(ROUND(A1,2)1,\"\",TEXT(INT(ROUND(A1,2)),\"[dbnum2]\")0][dbnum2];[0]负[dbnum2];;\");\"1%,\"元整\",)),\"零角\",IF(ABS(A1)1,,\"零\")),\"零分\",\"整\")
|