Excel公式收集

1.财务金额大写转换
C2=1005.6:
="人民币:"&IF(C2=INT(C2),NUMBERSTRING(INT(C2),2)&"元整",IF(C210=INT(C210),NUMBERSTRING(INT(C2),2)&"元"&NUMBERSTRING(INT(C210)-INT(C2)10,2)&"角整",IF(ROUNDDOWN(C210-INT(C2)10,0)=0,NUMBERSTRING(INT(C2),2)&"元零"&NUMBERSTRING(ROUND(C2100-INT(C210)10,0),2)&"分",NUMBERSTRING(INT(C2),2)&"元"&NUMBERSTRING(INT(C210)-INT(C2)10,2)&"角"&NUMBERSTRING(ROUND(C2100-INT(C210)10,0),2)&"分")))