[求助]金额大小写转换后四舍五入的问题

alonliu

请教各位大虾，在制作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编辑过]

淼漫

处理C14即可＝round(C14,0)