EXCEL表中 将阿拉伯数字转换成圆角分的大写形式

1、打开EXCEL表

3、在你所需要生成转换后的金额数字的表格中粘贴如下公式：=IF(A1<0,"金额不能为负值",IF(A1=0,"零圆",IF(A1<1,IF(INT(10*A1)=0,TEXT(INT(100*A1),"[DBNUM2]")&"分",TEXT(INT(10*A1),"[DBNUM2]")&"角"&IF((INT(100*A1)-INT(10*A1)*10)=0,"",TEXT(INT(100*A1-INT(10*A1)*10),"[DBNUM2]")&"分")),TEXT(INT(A1),"[DBNUM2]")&"圆"&IF((A1-INT(A1))=0,"整",IF(INT(10*(A1-INT(A1)))=0,TEXT(INT(100*(A1-INT(A1))),"[DBNUM2]")&"分",TEXT(INT(10*(A1-INT(A1))),"[DBNUM2]")&"角"&IF((INT(100*(A1-INT(A1)))-INT(10*(A1-INT(A1)))*10)=0,"",TEXT(INT(100*(A1-INT(A1))-INT(10*(A1-INT(A1)))*10),"[DBNUM2]")&"分"))))))我做演示用，就直接贴在B1中了。