excel数字金额自动变大写金额.doc

文档介绍：excel数字金额自动变大写金额=IF(ROUND(A2,2)<0,"无效数值",IF(ROUND(A2,2)=0,"零",IF(ROUND(A2,2)<1,"",TEXT(INT(ROUND(A2,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10=0,IF(INT(ROUND(A2,2))*(INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"整",TEXT((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10),"[dbnum2]")&"分")))=IF(ROUND(A1,2)<0,"无效数值",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(ROUND(A1,2))*(INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"整",TEXT((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10),"[dbnum2]")&"分")))=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHT(FIXED(A1),2),"元[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"元整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")=TEXT(A1*100,"人民币0拾0万0仟0佰0拾0元0角0分[dbnum2]")EXCEL如何用等差序列标上行号如要标出1、5、9……=IF(MOD((ROW()-1),4)=0,ROW(),"")如要标2、4、6……=IF(MOD((ROW()*1),2)=0,ROW(),"")A列数据,在B列输入公式=if(countif(a:a,a1)>1,"数据已存在",""),假设你把你的数据放在A列的,现在选中整个A列,进行以下操作:1、选择菜单“格式-条件格式”,打开条件格式设置对话窗口2、把第一个框拉下来选择“公式”3、在第二个框内输入=COUNTIF(A:A,A1)>14、点“格式”按钮,在“图案”标签中选红色5、逐层确定,直到返回到工作表现在你在A列中输入任何重复的内容,重复内容的单元格都会自动变成红底色,你就能及时发现重复的内容了。=IF(A15>