关于金额大写保留小数点后4位,格式化到厘的实现

楼主
山西省晋中市榆次区龙湖大街229号天缘大厦17楼
关于金额大写保留小数点后4位,格式化到厘的实现
一位朋友的提问,在这贴出来
https://bbs.fanruan.com/thread-132686-1-1.html


@逆光暖伤i


A3 为数字单元格,曲线救国吧[color=rgba(10, 18, 32, 0.64)],分会四舍五入,自己考虑吧

CONCATENATE(CNMONEY(round(A3,4)),
if(left(right(round(A3,4),2),1)=0,"零毫",
if(left(right(round(A3,4),2),1)=1,"壹毫",
if(left(right(round(A3,4),2),1)=2,"贰毫",
if(left(right(round(A3,4),2),1)=3,"叁毫",
if(left(right(round(A3,4),2),1)=4,"肆毫",
if(left(right(round(A3,4),2),1)=5,"伍毫",
if(left(right(round(A3,4),2),1)=6,"陆毫",
if(left(right(round(A3,4),2),1)=7,"柒毫",
if(left(right(round(A3,4),2),1)=8,"捌毫","玖毫",))))))))),
if(right(round(A3,4),1)=0,"零厘",
if(right(round(A3,4),1)=1,"壹厘",
if(right(round(A3,4),1)=2,"贰厘",
if(right(round(A3,4),1)=3,"叁厘",
if(right(round(A3,4),1)=4,"肆厘",
if(right(round(A3,4),1)=5,"伍厘",
if(right(round(A3,4),1)=6,"陆厘",
if(right(round(A3,4),1)=7,"柒厘",
if(right(round(A3,4),1)=8,"捌厘","玖厘",))))))))))






编辑于 2020-8-21 16:33  
编辑于 2020-8-21 16:57  
分享扩散:

沙发
发表于 2020-8-24 08:15:06
金额到厘现实工作和生活中有意义吗?
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

2回帖数 2关注人数 8121浏览人数
最后回复于:2020-9-1 09:37

返回顶部 返回列表