1、下图表格，怎样把A列的金额分列，把数字对应填充在单位的下面，并且转换成大写。
2、本例主要利用函数解决，在B3输入公式=IF(A3>=100000000,INT(A3/100000000)-INT(A3/1000000000)*10,IF(A3<10000000,"","￥"))，点击编辑栏的确认按钮或敲回车键得出结果。
3、接着在C3、D3、E3分别输入公式=IF(A补朱锚卦3>=10000000,INT(A3/10000000像粜杵泳)-INT(A3/100000000)*10,IF(A3<1000000,"","￥"))、=IF(A3>=1000000,INT(A3/1000000)-INT(A3/10000000)*10,IF(A3<100000,"","￥"))、=IF(A3>=100000,INT(A3/100000)-INT(A3/1000000)*10,IF(A3<10000,"","￥"))。
4、在F3、G3、H3输入公式=IF(A3>=10000,INT(A3/10000)-INT(A3/100000)*10,IF(A3<1000,"","￥"))、=IF(A3>=1000,INT(A3/1000)-INT(A3/10000)*10,IF(A3<100,"","￥"))、=IF(A3>=100,INT(A3/100)-INT(A3/1000)*10,IF(A3<10,"","￥"))。
5、在剩下的四个单位单元格中分别输入公式=IF(A3>=10,INT(A3/10)-INT(A3/100)*10,IF(A3<1,"","￥"))、=IF(A3>=1,INT(A3/1)-INT(A3/10)*10,IF(A3<0.1,"","￥"))、=IF(A3>=0.1,INT(A3/0.1)-INT(A3/1)*10,IF(A3<0.01,"","￥"))、=INT(A3/0.01)-INT(A3/0.1)*10。
6、在大写金额的单元格中输入公式=IF(ROUND(A3,2)<0,"蕾蓄允嘞错误数据",IF(ROU绿覆冗猩ND(A3,2)=0,"零",IF(ROUND(A3,2)<1,"",TEXT(INT(ROUND(A3,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A3,2)*10)-INT(ROUND(A3,2))*10=0,IF(INT(ROUND(A3,2))*(INT(ROUND(A3,2)*100)-INT(ROUND(A3,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A3,2)*10)-INT(ROUND(A3,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A3,2)*100)-INT(ROUND(A3,2)*10)*10)=0,"整",TEXT((INT(ROUND(A3,2)*100)-INT(ROUND(A3,2)*10)*10),"[dbnum2]")&"分")))。
7、最后，选中B3:M3下拉复制公式，得出结果，如图。
