电子表格中小写直接转大写

发布网友发布时间：2022-04-25 15:50

共2个回答

热心网友时间：2023-10-14 15:16

=IF(A12<0,"负",)&TEXT(TRUNC(ABS(A12)),"[DBNum2]G/通用格式")&"元"&IF(ROUND(A12,3)=ROUND(A12,),"整",TEXT(RIGHT(TRUNC(A12*10),1),"[DBNum2]G/通用格式")&"角"&IF(ROUND(A12,3)=ROUND(A12,1),"整",TEXT(RIGHT(ROUND((A12*100),),1),"[DBNum2]G/通用格式")&"分"))

用函数公式，假如你的小写金额在A12单元格，如果不是，把A12改成你的小写金额所在的单元格。

热心网友时间：2023-10-14 15:17

=IF(ROUND(D8,2)<0,"无效数值",IF(ROUND(D8,2)=0,"零",IF(ROUND(D8,2)<1,"",TEXT(INT(ROUND(D8,2)),"[dbnum2]")&"元")&IF(INT(ROUND(D8,2)*10)-INT(ROUND(D8,2))*10=0,IF(INT(ROUND(D8,2))*(INT(ROUND(D8,2)*100)-INT(ROUND(D8,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(D8,2)*10)-INT(ROUND(D8,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(D8,2)*100)-INT(ROUND(D8,2)*10)*10)=0,"整",TEXT((INT(ROUND(D8,2)*100)-INT(ROUND(D8,2)*10)*10),"[dbnum2]")&"分")))