方法一:
=IF((A9-INT(A9))=0,TEXT(A9,"[DBNUM2]")&"元整",IF(INT(A9*10)-A9*10=0,TEXT(INT(A9),"[DBNUM2]")&"元"&TEXT((INT(A9*10)-INT(A9)*10),"[DBNUM2]")&"角整",TEXT(INT(A9),"[DBNUM2]")&"元"&IF(INT(A9*10)-INT(A9)*10=0,"零",TEXT(INT(A9*10)-INT(A9)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A9,1),"[DBNUM2]")&"分"))
方法二:
=IF(INT(A9)*100=A9*100,TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元整",IF(INT(A9*10)=A9*10,TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元"&TEXT(A9*10-INT(A9)*10,"[$-0804][DBNum2]G/通用格式")&"角整",TEXT(INT(A9),"[$-0804][DBNum2]G/通用格式")&"元"&IF(INT(A9*10)=INT(A9)*10,"零",TEXT(RIGHT(INT(A9*10)),"[$-0804][DBNum2]G/通用格式")&"角")&TEXT(RIGHT(A9*100),"[$-0804][DBNum2]G/通用格式")&"分"))