下面这段文字怎么在同一单元格内自动生成大小写金额，金额部分是引用G21单元格数字？

发布网友发布时间：2022-04-30 18:14

共3个回答

热心网友时间：2023-10-09 10:28

="现申请支付本期工程款人民币："&SUBSTITUTE(SUBSTITUTE(IF(-RMB(G21),IF(G21>0,,"负")&TEXT(INT(ABS(G21)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(G21,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(G21^2<1,,"零")),"零分","整")&"("&G21&")"&"，请予核准"

热心网友时间：2023-10-09 10:29

IF((INT(G21*10)-INT(G21)*10)=0,TEXT(INT(G21),"[DBNum2]G/通用格式")&"元"&IF((INT(G21*100)-INT((G21)*10)*10)=0,"整","零"&TEXT(INT(G21*100)-INT(G21*10)*10,"[DBNum2]G/通用格式")&"分"),TEXT(INT(G21),"[DBNum2]G/通用格式")&"元"&IF((INT(G21*100)-INT((G21)*10)*10)=0,TEXT((INT(G21*10)-INT(G21)*10),"[DBNum2]G/通用格式")&"角整",TEXT((INT(G21*10)-INT(G21)*10),"[DBNum2]G/通用格式")&"角"&TEXT(INT(G21*100)-INT(G21*10)*10,"[DBNum2]G/通用格式")&"分"))&"（￥"&G21&"），请予核准。"

热心网友时间：2023-10-09 10:29

金额=IF(g21,TEXT(INT(g21),"[dbnum2]")&IF(INT(g21)=g21,"元整","元")&TEXT(--RIGHT(INT(g21*10)),IF(--RIGHT(g21*100),"[=0]零;[dbnum2]#角","[dbnum2]#角整;;"))&TEXT(--RIGHT(g21*100),"[dbnum2]#分;;"),"")&"("&TEXT(g21,"￥#,##0.00_ ")&")"追问文字呢？

追答="现申请支付本期工程款人民币："&IF(g21,TEXT(INT(g21),"[dbnum2]")&IF(INT(g21)=g21,"元整","元")&TEXT(--RIGHT(INT(g21*10)),IF(--RIGHT(g21*100),"[=0]零;[dbnum2]#角","[dbnum2]#角整;;"))&TEXT(--RIGHT(g21*100),"[dbnum2]#分;;"),"")&"("&TEXT(g21,"￥#,##0.00_ ")&")"&"，请予核准。"