房地产会计网

标题: Excel实现大小写金额转换的代码 [打印本页]

作者: 银河飞雪 时间: 2007-9-10 12:47
标题: Excel实现大小写金额转换的代码
‘=IF(ISNUMBER($N$49),IF($N$49<0,"无效数值",IF($N$49<0.005,"零",IF($N$49<0.995,"",TEXT(INT($N$49+0.005),"[dbnum2]")&"元")&IF(LEFT(RIGHT(FIXED($N$49,2),2),1)="0",IF(RIGHT(FIXED($N$49,2),1)="0","",IF($N$49>0.995,"零","")),TEXT(LEFT(RIGHT(FIXED($N$49,2),2),1),"[dbnum2]")&"角")&IF(RIGHT(FIXED($N$49,2),1)="0","整",TEXT(RIGHT(FIXED($N$49,2),1),"[dbnum2]")&"分"))),"非数值!")

大小写在财务工作中经常要用到,希望能给大家带来帮助

作者: 威海本溪人 时间: 2009-7-10 15:02
唉，看不明白

欢迎光临房地产会计网 (https://www.fdckj.com/)