Office中国论坛/Access中国论坛

标题: [求助]金额大小写转换后四舍五入的问题 [打印本页]

作者: alonliu 时间: 2005-6-28 19:32
标题: [求助]金额大小写转换后四舍五入的问题
请教各位大虾，在制作Excel表格时遇到需要将金额转换大小写，并且要求四舍五入！请问该如何操作啊？谢谢！！！！！！！！！！！！！！！！！

我采用的函数如下：

=IF(C14=0,""&IF(C14=0,"",IF((C14-ROUND(C14,0))=0,(TEXT(INT(C14),"[DBnum2]")&"元整"),(TEXT(INT(C14),"[DBnum2]")&"元")&IF((RIGHT(C14,2)-RIGHT(C14,1))=0,"零",TEXT(ROUND((INT(((C14-INT(C14))*100)-RIGHT(C14,1))/10),0),"[dbnum2]")&"角")&IF((C14*10-INT(C14*10))=0,"",TEXT(ROUND(((C14*10-INT(C14*10))*10),0),"[dbnum2]")&"分")&"整")),""&IF(C14=0,"",IF((C14-ROUND(C14,0))=0,(TEXT(INT(C14),"[DBnum2]")&"元整"),(TEXT(INT(C14),"[DBnum2]")&"元")&IF((RIGHT(C14,2)-RIGHT(C14,1))=0,"零",TEXT(ROUND((INT(((C14-INT(C14))*100)-RIGHT(C14,1))/10),0),"[dbnum2]")&"角")&IF((C14*10-INT(C14*10))=0,"",TEXT(ROUND(((C14*10-INT(C14*10))*10),0),"[dbnum2]")&"分"))))

[此贴子已经被作者于2005-6-28 11:47:12编辑过]

作者: 淼漫 时间: 2005-6-28 20:54
处理C14即可＝round(C14,0)

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)