copy左下面條formula落excel 但出左-> 港幣/通用格式元
=IF(COUNT(A1),"港幣"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[dbnum2]G/通用格式元")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整"),"參","叁"),"")
點解呢?
我用office 2003
請幫忙 無言感激!!
點解會出 -> 港幣/通用格式元
2013-02-27 6:55 pm
回答 (1)
2013-02-28 3:26 pm
✔ 最佳答案
Please try to change the formula as follows:=IF(COUNT(A1),"港幣"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[dbnum2]GENERAL元")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整"),"參","叁"),"")
i.e. "G/通用格式" --> "GENERAL"
收錄日期: 2021-04-24 10:36:43
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130227000051KK00079