| skylee |
2005-12-21 00:08 |
可以使用公式如下：
=IF(ISTEXT(D5),"","(人民币)"&TEXT(INT(D5),"[dbnum2]")&"元"&IF(INT(D5*10)-INT(D5)*10=0,"",TEXT(INT(D5*10)-INT(D5)*10,"[dbnum2]")&"角")&IF(INT(D5*100)-INT(D5*10)*10=0,"整",TEXT(INT(D5*100)-INT(D5*10)*10,"[dbnum2]")&"分"))
将D5换成你自己的单元格就行了
或这个：
=IF(A1<0,"金额为负无效",IF(OR(A1=0,A1=""),"零元整",IF(A1<1,"",TEXT(INT(A1),"[DBNum2]G/通用格式")&"元")&IF(INT(A1*10)-INT(A1)*10=0,IF(INT(A1)*(INT(A1*100)-INT(A1*10)*10)=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[DBNum2]G/通用格式")&"角")&IF((INT(A1*100)-INT(A1*10)*10)=0,"整",TEXT((INT(A1*100)-INT(A1*10)*10),"[DBNum2]G/通用格式")&"分"))) |
|