输入小写金额 大写金额自动生成的方法 简单实用) 平时工作用到EXCEL时,经常会遇到输入小写金额,然后还得把大写金额再打一遍,比较麻烦,现在只需输入小写金额,大写金额则会自动随着变化,我刚刚试过,很实用,真的非常棒! =IF(A1<0,"无效值",IF(A1=0,"零元",IF(A1<1,"",TEXT(INT(A1),"[DBNUM2]")&"元")&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]")&"角")&IF(INT(A1*100)-INT(A1*10)*10=0,"整",TEXT(INT(A1*100)-INT(A1*10)*10,"[DBNUM2]")&"分"))) http://hi.baidu.com/万盘皆缘/blog/item/f |
|