为什么这里转大写后金额显示不对呢，求求各位大神帮助解答

FineReport yzm227722 发布于 2023-12-8 11:05

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

ID1208Lv6高级互助
发布于2023-12-8 11:08（编辑于 2023-12-8 14:35）

=CONCATENATE(CNMONEY(FORMAT(A1,"00.0000")),SWITCH(MID(FORMAT(A1,"00.0000"),FIND(".",FORMAT(A1,"00.0000"))+3,1),'0', "零", '1', "壹", '2', "贰", "3", "叁", '4', "肆", "5", "伍", "6", "陆", '7', "柒", '8', "捌", '9', "玖")+"厘",SWITCH(MID(FORMAT(A1,"00.0000"),FIND(".",FORMAT(A1,"00.0000"))+4,1),'0', "零", '1', "壹", '2', "贰", "3", "叁", '4', "肆", "5", "伍", "6", "陆", '7', "柒", '8', "捌", '9', "玖")+"毫")

举报收起评论(10)

yzm227722(提问者) 我这里需要精确到毫

2023-12-08 13:13

ID1208 回复 yzm227722(提问者) if判断转化一下，参照上面截图

2023-12-08 13:27

yzm227722(提问者) 回复 ID1208 1210.10 大写应该是壹仟贰佰壹拾元壹角吧

2023-12-08 13:34

yzm227722(提问者) 回复 ID1208 我看帮助文档里是这么写的，有些数据转出来是对的，有些就是提问这种转出来是错误的，还有一种转出来大写是空的：SWITCH(LEN(MID(G8,FIND(\".\",G8)+1,100)),0,CNMONEY(G8),1,CNMONEY(G8),2,CNMONEY(G8),3,CONCATENATE(CNMONEY(left(G8,LEN(G8)-1)),SWITCH(INDEXOF(G8, FIND(\".\",G8)+2),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\",\"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"厘\"),4,CONCATENATE(CNMONEY(left(G8,LEN(G8)-2)),,SWITCH(INDEXOF(G8, FIND(\".\",G8)+2),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\",\"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"厘\"+SWITCH(INDEXOF(G8,FIND(\".\",G8)+3),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\", \"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"毫\"))

2023-12-08 13:37

ID1208 回复 yzm227722(提问者) 可能是我理解错了，我以为角的别称是毫

2023-12-08 13:50

还有5条评论点击查看

华莉星宸Lv7资深互助
发布于2023-12-8 11:08（编辑于 2023-12-8 14:41）

CNMONEY(number,unit)返回人民币大写。

number:需要转换的数值型的数。

unit:单位，"s","b","q","w","sw","bw","qw","y","sy","by","qy","wy"分别代表“拾”，“佰”，“仟”，“万”，“拾万”，“佰万”，“仟万”，“亿”，“拾亿”，“佰亿”，“仟亿”，“万亿”。

备注:单位可以为空，如果为空，则直接将number转换为人民币大写，否则先将number与单位的进制相乘，然后再将相乘的结果转换为人民币大写。

示例:

CNMONEY(1200)等于壹仟贰佰圆整。

CNMONEY(12.5,"w")等于壹拾贰万伍仟圆整。

CNMONEY(56.3478,"bw")等于伍仟陆佰叁拾肆万柒仟捌佰圆整。

CNMONEY(3.4567,"y")等于叁亿肆仟伍佰陆拾柒万圆整。

文本函数概述-https://help.fanruan.com/finereport10.0/doc-view-824.html

https://help.fanruan.com/finereport10.0/doc-view-824.html#3

本地化公式集合-https://help.fanruan.com/finereport10.0/doc-view-4568.html

if(FIND(".", G8) = 0, CNMONEY(G8), SWITCH(LEN(MID(G8, FIND(".", G8) + 1, 100)), 0, CNMONEY(G8), 1, CNMONEY(G8), 2, CNMONEY(G8), 3, CONCATENATE(CNMONEY(left(G8, LEN(G8) - 1)), SWITCH(INDEXOF(G8, FIND(".", G8) + 2), '0', "零", '1', "壹", '2', "贰", "3", "叁", '4', "肆", "5", "伍", "6", "陆", '7', "柒", '8', "捌", '9', "玖") + "厘"), 4, CONCATENATE(CNMONEY(left(G8, LEN(G8) - 2)), , SWITCH(INDEXOF(G8, FIND(".", G8) + 2), '0', "零", '1', "壹", '2', "贰", "3", "叁", '4', "肆", "5", "伍", "6", "陆", '7', "柒", '8', "捌", '9', "玖") + "厘" + SWITCH(INDEXOF(G8, FIND(".", G8) + 3), '0', "零", '1', "壹", '2', "贰", "3", "叁", '4', "肆", "5", "伍", "6", "陆", '7', "柒", '8', "捌", '9', "玖") + "毫")))

举报收起评论(3)

yzm227722(提问者) 我这里需要精确到毫，用了转大写精确到毫的公式，有的数字转大写是对的，这个显示就不对了：SWITCH(LEN(MID(G8,FIND(\".\",G8)+1,100)),0,CNMONEY(G8),1,CNMONEY(G8),2,CNMONEY(G8),3,CONCATENATE(CNMONEY(left(G8,LEN(G8)-1)),SWITCH(INDEXOF(G8, FIND(\".\",G8)+2),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\",\"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"厘\"),4,CONCATENATE(CNMONEY(left(G8,LEN(G8)-2)),,SWITCH(INDEXOF(G8, FIND(\".\",G8)+2),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\",\"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"厘\"+SWITCH(INDEXOF(G8,FIND(\".\",G8)+3),\'0\',\"零\",\'1\',\"壹\",\'2\',\"贰\",\"3\",\"叁\",\'4\',\"肆\", \"5\",\"伍\",\"6\",\"陆\",\'7\',\"柒\",\'8\',\"捌\",\'9\',\"玖\")+\"毫\"))

2023-12-08 13:14

华莉星宸回复 yzm227722(提问者) 试试 if(FIND(\".\", G8) = 0, CNMONEY(G8), SWITCH(LEN(MID(G8, FIND(\".\", G8) + 1, 100)), 0, CNMONEY(G8), 1, CNMONEY(G8), 2, CNMONEY(G8), 3, CONCATENATE(CNMONEY(left(G8, LEN(G8) - 1)), SWITCH(INDEXOF(G8, FIND(\".\", G8) + 2), \'0\', \"零\", \'1\', \"壹\", \'2\', \"贰\", \"3\", \"叁\", \'4\', \"肆\", \"5\", \"伍\", \"6\", \"陆\", \'7\', \"柒\", \'8\', \"捌\", \'9\', \"玖\") + \"厘\"), 4, CONCATENATE(CNMONEY(left(G8, LEN(G8) - 2)), , SWITCH(INDEXOF(G8, FIND(\".\", G8) + 2), \'0\', \"零\", \'1\', \"壹\", \'2\', \"贰\", \"3\", \"叁\", \'4\', \"肆\", \"5\", \"伍\", \"6\", \"陆\", \'7\', \"柒\", \'8\', \"捌\", \'9\', \"玖\") + \"厘\" + SWITCH(INDEXOF(G8, FIND(\".\", G8) + 3), \'0\', \"零\", \'1\', \"壹\", \'2\', \"贰\", \"3\", \"叁\", \'4\', \"肆\", \"5\", \"伍\", \"6\", \"陆\", \'7\', \"柒\", \'8\', \"捌\", \'9\', \"玖\") + \"毫\")))

2023-12-08 14:41