| 人民币大写: | =1,IF(F10=TRUNC(F10),TEXT(TRUNC(F10),"[DBNUM2]")&"元整 ",IF(F10*10=TRUNC(F10*10),TEXT(TRUNC(F10),"[DBNUM2]")&"元 "&TEXT(ABS(TRUNC(F10*10)-TRUNC(F10)*10),"[DBNUM2]")&"角整 ",TEXT(TRUNC(F10),"[DBNUM2]")&"元"&IF(ABS(F10)-TRUNC(ABS(F10))<0.1,"零 ",TEXT(ABS(TRUNC(F10*10)-TRUNC(F10)*10),"[DBNUM2]")&"角 ")&TEXT(FIXED(ABS(F10)*100-INT(ABS(F10)*10)*10,0),"[DBNUM2]")&"分 ")),IF(ABS(F10)*10-INT(ABS(F10)*10)=0,TEXT(TRUNC(F10*10),"[DBNUM2]")&"角整 ",IF(ABS(ABS(F10)-TRUNC(ABS(F10)))叁仟壹佰元整 | |