excel怎么让用公式计算的金额大写带括号？

这是大写金额的公式=IF(B8=0,"",IF(B8<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(B8)),"[DBNum2]")&"元"&TEXT(RIGHT(TEXT(B8,".00"),2),"[DBNum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零"),"零元零",""))，想让以上公式计算的结果带着括号。也可以说是让阿拉伯数字输出为中文大写金额并带括号。

举报该问题

推荐答案 2020-10-29

ä½ ç°å¨çå¬å¼æææ¯ãåæ¾åæ´ãè¿æ ·çææï¼ä½ å¸æä¿®æ¹ä¸ºãï¼åæ¾åæ´ï¼ãè¿æ ·åï¼é£ä¹å¯ä»¥è¿æ ·åï¼
="(" & ç°å¨çå¬å¼ & ")"
æç»ä½ ç²è´´ä¸å»æ¯ï¼
="(" & IF(B8=0,"",IF(B8<0,"è´","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(B8)),"[DBNum2]")&"å"&TEXT(RIGHT(TEXT(B8,".00"),2),"[DBNum2]0è§0å"),"é¶è§é¶å","æ´"),"é¶å","æ´"),"é¶è§","é¶"),"é¶åé¶","")) & ")"

温馨提示：答案为网友推荐，仅供参考

当前网址：http://22.wendadaohang.com/zd/0626ThC0ITfh60hSSI.html

相似回答

EXCEL大写金额公式前面怎么添加符号?答：B4:="大写:"&TEXT(C4,"[DBNum2][$RMB]G/通用格式")

EXCEL大写金额公式前面怎么添加符号?答：=IF(C1=0,"","⊗"&IF(AND(ISERR(FIND("拾万零",TEXT(INT(C1),"[dbnum2]"))),ISERR(FIND("拾万元",TEXT(INT(C1),"[dbnum2]")&"元"))),SUBSTITUTE(TEXT(INT(C1),"[DBNum2]"),"拾万","拾万零"

大家正在搜

excel自动大写金额公式 excel自动生成大写金额公式 excel怎么自动大写金额 excel表格大写公式怎么设置表格里金额大写怎么设置公式 excel大写金额等于小写 excel表金额小写转大写 excel怎么小写变大写 excel大写金额函数