1、模式一：汇总表格有合计
2、把合计总额转换为大写函数：=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(D18),"[dbnum2]")&TEXT(MOD(D18,2)*100,"[dbnum2]元0角0分"),"零角零分",),"零角",),"零分",)&"整"
3、解析:int（）取整mod（）取余（注：涯箨唁峦*100是把余数变整）text（）定义文本格式substitute（text，old-text，new-text）函数公式中TEXT(INT(肛舀辨乔D18),"[dbnum2]")&TEXT(MOD(D18,2)*100,"[dbnum2]元0角0分")该部分为里面第一个substitute函数的“text”，"零角零分"为"old-text"SUBSTITUTE(TEXT(INT(D18),"[dbnum2]")&TEXT(MOD(D18,2)*100,"[dbnum2]元0角0分"),"零角零分",)该部分为中间substitute函数的“text”，“零角”为"old-text"SUBSTITUTE(SUBSTITUTE(TEXT(INT(D18),"[dbnum2]")&TEXT(MOD(D18,2)*100,"[dbnum2]元0角0分"),"零角零分",),"零角",)该部分为最外层substitute函数的“text”，“零分”为"old-text"
4、模式弛阻廖娓二：也可以写成这样：小写合计函数：="小写："&ROUND(SUM(E2:E4),2)&"元"大写合计函数：="大写："&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(SUM(E2:E4)),"[dbnum2]")&TEXT(MOD(SUM(E2:E4),1)*100,"[dbnum2]元0角0分"),"零角零分",),"零角",),"零分",)&"整"
5、网络上有些把“整”放到函数里面，有的时候会不显示整函数：=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(D18),"[dbnum2]")&TEXT(MOD(D18,2)*100,"[dbnum2]元0角0分"),"零角零分","整"),"零角","整"),"零分","整")
