表达式:
=IF(ISNUMBER(H21),IF(INT(H21),TEXT(INT(H21),"[dbnum2]")&"元",)&IF(INT(H21*10)-INT(H21)*10,TEXT(INT(H21*10)-INT(H21)*10,"[dbnum2]")&"角",IF(INT(H21)=H21,,IF(H21<0.1,,"零")))&IF(ROUND((H21)*100-INT(H21*10)*10,),TEXT(ROUND(H21*100-INT(H21*10)*10,),"[dbnum2]")&"分","整"),"") |