在Excel怎么自动显示大写元整金额答:1、打开EXCEL,为方便讲解,在此建立了两列,如图 2、在B2 单元格输入以下公式:=IF(MOD(A2,1)=0,TEXT(INT(A2),"[DBNUM2]")&"元"&"整",TEXT(INT(A2),"[DBNUM2]")&"元"&TEXT(MID(A2,LEN(INT(A2))+2,1),"[DBNUM2]D角")&TEXT(MID(A2,LEN(INT(A2))+3,1),"[DBNUM2]D分...
excel大写金额自动生成答:B2单元格输入以下公式:=IF(A20,"负","")IF(TRUNC(A2)=A2,TEXT(IF(A20,-A2,A2),"")"元整",IF(TRUNC(A2*10)=A2*10,TEXT(TRUNC(IF(A20,-A2,A2)),"")"元"TEXT(RIGHT(A2),"")"角整",TEXT(TRUNC(A2),"")"元"IF(ISNUMBER(FIND(".0",A2)),"零",TEXT(LEFT(RIGHT(A2,2))...