导航

04 2015 档案

Excel小写金额转大写金额公式

摘要：=IF(ROUND(A6,2)<0,"无效数值",IF(ROUND(A6,2)=0,"零",IF(ROUND(A6,2)<1,"",TEXT(INT(ROUND(A6,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A6,2)*10)-INT(ROUND(A6,2))*10=0,... 阅读全文

posted @ 2015-04-22 16:59 曙光城邦 阅读(872) 评论(0) 推荐(0)