)&"[dbnum2]"[dbnum2]人民币G/)&IF((INT(A1*100)-INT(A1*10)*10)=0,TEXT(INT(A1);)&");)) 这个是假设A1为数字格式单元格,",在任意单元格内粘贴下面公式即可显示大定金额,TEXT((INT(A1*100)-INT(A1*10)*10)。如果是H4的数字,",TEXT(INT(A1*10)-INT(A1)*10;分"通用格式",")&"",IF(INT(A1)*(INT(A1*100)-INT(A1*10)*10)=0;元",在任意单元格内粘贴下面公式即可显示大定金额;;零"角"整"&IF(INT(A1*10)-INT(A1)*10=0;[dbnum2]",","=0,"。这个公式怎么修改,;=IF(A1<
第1个回答 2020-02-20
方法:
1、打开EXCEL表格,A1输入小写金额,在C1列输入:=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")
2、确定后效果如图。