在EXCEL表格里自动生成金额大写的同时加入汉字答:="大写总金额:"&IF(ROUND(A1,2)=0,"",IF(ROUND(ABS(A1),2)>=1,TEXT(INT(ROUND(ABS(A1),2)),"[DBNum2]")&"元","")&IF(RIGHT(TEXT(A1,".00"),2)*1=0,"整",IF(RIGHT(TEXT(A1,".00"),4)*1>=1,
在表格里怎么把小写变成大写金额答:假设总金额右边的阿拉伯数字所在的单元格是D3单元格,那么在大写区所在的单元格输入公式="合计(大写):"&IF(ISERR(FIND(".",D3)),TEXT(D3,"[dbnum2]")&"元零角零分",TEXT(LEFT(D3,FIND(".",D3)-1),"[dbnum2]")&"元"&TEXT(MID(D3,FIND(".",D3)+1,1),"[dbnum2]")&"...
如何在表格中设置自动显示数字的大写金额答:1 =SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A2)),"[>0][dbnum2]G/通用格式元;[<0]负[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零")),"零分","整")2 =SUBSTITUTE(SUBSTITUTE(IF(A2>-0....