如何将总金额小写转换为大写金额

rasy521 · 发表于 2012-12-22 11:00

如何将总金额小写转换为以上大写金额，谢谢

rasy521 · 发表于 2012-12-22 11:02

小写转换大写

fkeih_007 · 发表于 2012-12-22 11:16

="人民币"&SUBSTITUTE(IF(F11>-0.5%,,"(负)")&TEXT(INT(FIXED(ABS(F11))),"[dbnum2]G/通用格式元")&TEXT(RIGHT(FIXED(F11),2),"[dbnum2]0角0分;;"&IF(ABS(F11)>1%,"整",)),"零分","整")&"(含税)"

杨小军 · 发表于 2012-12-22 11:22

见附件......

蓝色海岸线008 · 发表于 2012-12-22 11:31

学习了，挺有收获的。

xinyuezhang · 发表于 2012-12-22 11:32

本帖最后由 xinyuezhang 于 2012-12-22 11:33 编辑

漆采购计划 - 副本.zip (9.48 KB, 下载次数: 16)
=IF(ROUND(F11,2)<0,"无效数值",IF(ROUND(F11,2)=0,"零",IF(ROUND(F11,2)<1,"",TEXT(INT(ROUND(F11,2)),"[dbnum2]")&"元")&IF(INT(ROUND(F11,2)*10)-INT(ROUND(F11,2))*10=0,IF(INT(ROUND(F11,2))*(INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(F11,2)*10)-INT(ROUND(F11,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10)=0,"整",TEXT((INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10),"[dbnum2]")&"分")))

rasy521 · 发表于 2012-12-22 13:08

xinyuezhang 发表于 2012-12-22 11:32
=IF(ROUND(F11,2)

请问后面在加上含税价怎么弄呢。

xinyuezhang · 发表于 2012-12-22 13:25

本帖最后由 xinyuezhang 于 2012-12-22 13:26 编辑

rasy521 发表于 2012-12-22 13:08
请问后面在加上含税价怎么弄呢。

=IF(ROUND(F11,2)<0,"无效数值",IF(ROUND(F11,2)=0,"零",IF(ROUND(F11,2)<1,"",TEXT(INT(ROUND(F11,2)),"[dbnum2]")&"元")&IF(INT(ROUND(F11,2)*10)-INT(ROUND(F11,2))*10=0,IF(INT(ROUND(F11,2))*(INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(F11,2)*10)-INT(ROUND(F11,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10)=0,"整",TEXT((INT(ROUND(F11,2)*100)-INT(ROUND(F11,2)*10)*10),"[dbnum2]")&"分")))&"含税价"

湛蓝天空/mg · 发表于 2013-3-7 16:34

学习了，挺有收获的。

湛蓝天空/mg · 发表于 2013-3-7 16:47

公式太长了

		自动登录	找回密码
密码			免费注册

[求助] 如何将总金额小写转换为大写金额

小写转换大写