excel函数公式转换人民币大小写.doc

文档介绍：Excel 函数公式转换人民币大小写问题: 想将 A1 中人民币的小写数字,在 B1 中转***民币大写。解答:B1中输入=TEXT(A1*100,"[dbnum2] 0拾0万0仟0佰0拾0元0角0分")就可以了, 如果你不要拾万位,自己可以修改的,如=TEXT(A1*100,"[dbnum2]0 万0仟0佰0拾 0元0角0分")等形式都可以的。⑴已知: A1= 函数: B1 =TEXT(A1*100,"[dbnum2]0 拾0万0仟0佰0拾0元0角0分") 结果: 零拾零万零仟零佰零拾肆元伍角壹分⑵已知: A1= 函数: B1 =TEXT(A1*100,"[dbnum2]0 拾0万0仟0佰0拾0元0角0分") 结果: 肆拾伍万陆仟柒佰捌拾玖元贰角叁分⑶已知: A1= ( 注:位数不能超过拾万) 函数: B1 =TEXT(A1*100,"[dbnum2]0 拾0万0仟0佰0拾0元0角0分") 结果: 壹贰叁肆拾伍万陆仟柒佰捌拾玖元贰角叁分⑷已知: A1= 函数: B1=TEXT(A1*100,"[dbnum2]0 万0仟0佰0拾0元0角0分") 结果: 零万零仟零佰零拾肆元伍角壹分⑸已知: A1= 函数: B1=TEXT(A1*100,"[dbnum2] 0拾0元0角0分") 结果: 贰拾叁元贰角伍分⑹已知: B9= 函数: =IF(B9<=0,,TEXT(INT(B9),"[dbnum2] 人民币 G/ 通用格式")&" 元"&IF(INT(B9*10)-INT(B9)*10=0,IF(INT(B9)*(INT(B9*100)-INT(B9*10)*10)=0,""," 零"),TEXT(INT(B9*10)-INT(B9)*10,"[dbnum2]")&" 角")&IF((INT(B9*100)-INT(B9*10)*10)=0," 整",TEXT((INT(B9*100)-INT(B9*10)*10),"[dbnum2]")&" 分")) 结果:人民币壹亿贰仟叁佰肆拾伍万陆仟柒佰捌拾玖元壹角贰分⑺已知: B9= 函数: =IF(B9<=0,,TEXT(INT(B9),"[dbnum2]G/ 通用格式")&" 元"&IF(INT(B9*10)-INT(B9)*10=0,IF(INT(B9)*(INT(B9*100)-INT(B9*10)*10)=0,""," 零"),TEXT(INT(B9*10)-INT(B9)*10,"[dbnum2]")&" 角")&IF((INT(B9*100)-INT(B9*10)*10)=0," 整",TEXT((INT(B9*100)-INT(B9*10)*10),"[dbnum2]")&" 分")) 结果:壹亿贰仟叁佰肆拾伍万陆仟柒佰捌拾玖元壹角贰分⑻已知: B9= 函数: =IF(ROUND(B9,2)=0,"",IF(ROUND(ABS(B9),2)>=1,TEXT(INT(ROUND(ABS(B9),2)),"[DBNum2]")&" 元","")&IF(RIGHT(TEXT(B9,".00"),2)*1=0," 整",IF(RIGHT(TEXT(B9,".00"),4)