excel中同时显示小写和大写金额

大写在前小写在后

=" 总金额："&SUM(R29:R32)&"元"&"（大写："&IF((SUM(R29:R32)-INT(SUM(R29:R32)))=0,TEXT(SUM(R29:R32),"[DBNUM2]")&"元整）",IF(INT(SUM(R29:R32)*10)-SUM(R29:R32)*10=0,TEXT(INT(SUM(R29:R32)),"[DBNUM2]")&"元"&TEXT((INT(SUM(R29:R32)*10)-INT(SUM(R29:R32))*10),"[DBNUM2]")&"角整）",TEXT(INT(SUM(R29:R32)),"[DBNUM2]")&"元"&IF(INT(SUM(R29:R32)*10)-INT(SUM(R29:R32))*10=0,"零",TEXT(INT(SUM(R29:R32)*10)-INT(SUM(R29:R32))*10,"[DBNUM2]")&"角")&TEXT(RIGHT(SUM(R29:R32),1),"[DBNUM2]")&"分整）"))

小写在前大写在后

="合计金额："&IF((SUM(M14:M17)-INT(SUM(M14:M17)))=0,TEXT(SUM(M14:M17),"[DBNUM2]")&"元整",IF(INT(SUM(M14:M17)*10)-SUM(M14:M17)*10=0,TEXT(INT(SUM(M14:M17)),"[DBNUM2]")&"元"&TEXT((INT(SUM(M14:M17)*10)-INT(SUM(M14:M17))*10),"[DBNUM2]")&"角整",TEXT(INT(SUM(M14:M17)),"[DBNUM2]")&"元"&IF(INT(SUM(M14:M17)*10)-INT(SUM(M14:M17))*10=0,"零",TEXT(INT(SUM(M14:M17)*10)-INT(SUM(M14:M17))*10,"[DBNUM2]")&"角")&TEXT(RIGHT(SUM(M14:M17),1),"[DBNUM2]")&"分整"))&" （小写："&SUM(M14:M17)&"元）"