人民幣小寫(xiě)改大寫(xiě) 公式=IF(C12<0,"無(wú)效數(shù)值",IF(C12=0,"",IF(C12<1,"",TEXT(INT(C12),"[dbnum2]")&"元")&IF(INT(C12*10)-INT(C12)*10=0,IF(INT(C12)*(INT(C12*100)-INT(C12*10)*10)=0,"","零"),IF(AND((INT(C12)-INT(C12/10)*10)=0,INT(C12)>0),"零"&TEXT(INT(C12*10)-INT(C12)*10,"[dbnum2]")&"角",TEXT(INT(C12*10)-INT(C12)*10,"[dbnum2]")&"角"))&IF((INT(C12*100)-INT(C12*10)*10)=0,"整",TEXT(INT(C12*100)-INT(C12*10)*10,"[dbnum2]")&"分")))
|
|
來(lái)自: 水美草綠 > 《會(huì)計(jì)》