|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
<DIV class=quote><B>以下是引用<I>yzcg</I>在2005-1-16 17:12:00的发言:</B>
<P>下面给你一个,在A9中输入数字即可,如果是其他单元格,替换一下。</P>
<P>A1=IF(A9=0,"零",(IF(TRUNC(A9)=0,"",TEXT(TRUNC(A9),"[DBNum2]G/通用格式")&"元"))&(IF(AND(TRUNC(A9)<>0,TRUNC(A9*10)-TRUNC(A9)*10=0,TRUNC(A9*100)-TRUNC(A9*10)*10<>0),"零",IF(AND(TRUNC(A9)<>0,TRUNC(A9*10)-TRUNC(A9)*10=0,TRUNC(A9*100)-TRUNC(A9*10)*10=0),"整",IF(TRUNC(A9*10)-TRUNC(A9*10,-1)=0,"",TEXT(TRUNC(A9*10)-TRUNC(A9*10,-1),"[DBNum2]G/通用格式")&"角")))))&(IF(TRUNC(A9*100)-TRUNC(A9*10)*10=0,"",TEXT(TRUNC(A9*100)-TRUNC(A9*10)*10,"[DBNum2]G/通用格式")&"分"))</P></DIV>
向你敬礼!![em02] |
|