学习记录
学习记录
-
-
-
-
-
-
-
-
-
-
2022-08-31
-
昨日添加404页面。
今日记录EXCEL小写金额转为大写金额,用的时候需要删除换行。
=IF(F16="","",IF(ROUND(F16,2)=0,"零",IF(ROUND(F16,2)<0,"负","")
&IF(ROUND(ABS(F16),2)<1,"",TEXT(INT(ROUND(ABS(F16),2)),"[dbnum2]")&"圆")
&IF(INT(ROUND(ABS(F16),2)*10)-INT(ROUND(ABS(F16),2))*10=0,
IF(INT(ROUND(ABS(F16),2)*100)-INT(ROUND(ABS(F16),2)*10)*10=0,"","零"),
TEXT(INT(ROUND(ABS(F16),2)*10)-INT(ROUND(ABS(F16),2))*10,"[dbnum2]")&"角")
&IF((INT(ROUND(ABS(F16),2)*100)-INT(ROUND(ABS(F16),2)*10)*10)=0,"整",
TEXT((INT(ROUND(ABS(F16),2)*100)-INT(ROUND(ABS(F16),2)*10)*10),"[dbnum2]")&"分")))
-
-