设置的大小写转换公式不起作用

#大小写
正经牛
如图，我设置了公式（=SUBSTITUTE(SUBSTITUTE(IF(F22<0,"负","")&TEXT(TRUNC(ABS(ROUND(F22,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(F22,2))),"",TEXT(RIGHT(TRUNC(ROUND(F22,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(F22,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(F22,2),3))=".",TEXT(RIGHT(ROUND(F22,2)),"[DBNum2]")&"分",IF(ROUND(F22,2)=0,"","整")),"零元零",""),"零元","")），不知道为什么右边输入数字后，左边没有按照正常的大小写显示金额！
WPS表格 WPS表格 函数公式
重庆
浏览 89
收藏
2
分享
2 +1
1
+1
全部评论 1
 
蜗牛
ai给的答案，可以试试=IF(ROUND(A1,2)=0,"",IF(A1<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A1)),"[DBNum2]")&"元"&IF(ROUND(ABS(A1)-INT(ABS(A1)),2)=0,"整",TEXT(RIGHT(TEXT(ROUND(ABS(A1),2),".00"),2),"[DBNum2]0角0分")),"零元",IF(ROUND(ABS(A1),2)<1,,)),"零角","零"),"零分","整"),"零拾","零"),"零佰","零"),"零仟","零"),"零万","万"),"零亿","亿"),"亿万","亿"),"零零","零"),"零元","元"),"零万","万"),"零亿","亿"))
· 河南省
回复