點解會出 -> 港幣/通用格式元

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

請幫忙 無言感激!!

1 Answer

Rating
  • 7 years ago
    Favorite Answer

    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"

Still have questions? Get your answers by asking now.