EXCEL中如何用公式得出一个数值的大写?答:3. 然后,选择另一个单元格,在这个单元格中输入以下公式:="大写人民币:"&IF(TRUNC(A1)=0,"",TEXT(TRUNC(A1),"[DBNum2]G/通用格式")&"元")&IF(TRUNC(A1*10)-TRUNC(A1*10,-1)=0,IF(TRUNC(A1*100)-TRUNC(A1*100,-1)>0,"零",""),TEXT(TRUNC(A1*10)-TRUNC(A1*10,-1),"...
Excel人民币大写函数公式的三种常见公式写法答:excel人民币大写公式一:=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零")...