关于金额大写保留小数点后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
|