[专
题
快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题
]人民币大写转换公式
人民币金额小写转换为大写
转换公式
转换公式之一:
=IF(A1<0,"金额为负无效",IF(OR(A1=0,A1=""),"零元整
",IF(A1<1,"",TEXT(INT(A1),"[DBNum2]G/通用格式")&"元
")&IF(INT(A1*10)-INT(A1)*10=0,IF(INT(A1)*(INT(A1*100)-INT(A1*10)*10
)=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[DBNum2]G/通用格式")&"角
")&IF((INT(A1*100)-INT(A1*10)*10)=0,"整
",TEXT((INT(A1*100)-INT(A1*10)*10),"[DBNum2]G/通用格式")&"分")))
转换公式之二:
=IF(B8=0,"",CONCATENATE(IF(INT(ABS(B8))=0,"",TEXT(INT(ABS(B8)),"[DB
Num2]G/通用格式元
")),IF(INT(MID(RIGHT(FIXED(ABS(B8),2,1),2),1,1))=0,IF(INT(MID(RIGHT
(FIXED(B8,2,1),1),1,1))=0,"",IF(INT(ABS(B8))=0,"","零
")),TEXT(INT(MID(RIGHT(FIXED(B8,2,1),2),1,1)),"[DBNum2]G/通用格式角
")),IF(INT(MID(RIGHT(FIXED(B8,2,1),1),1,1))=0,"整
",TEXT(INT(MID(RIGHT(FIXED(B8,2,1),1),1,1)),"[DBNum2]G/通用格式分
"))))
转换公式之三:
=IF((A1-INT(A1))=0,TEXT(A1,"[DBNUM2]")&"元整
",IF(INT(A1*10)-A1*10=0,TEXT(INT(A1),"[DBNUM2]")&"元"&TEXT((INT(A1*10)-INT(A1)*10),"[DBNUM2]")&"角整
",TEXT(INT(A1),"[DBNUM2]")&"元"&IF(INT(A1*10)-INT(A1)*10=0,"零",TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角
")&TEXT(RIGHT(A1,1),"[DBNUM2]")&"分")) 转换公式之四:
=IF(ROUND(D1,2)<0,"无效数字",IF(ROUND(D1,2)=0,"零
",IF(ROUND(D1,2)<1,"",TEXT(INT(ROUND(D1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(D1,2)*10)-INT(ROUND(D1,2))*10=0,IF(INT(ROUND(D1,2))
*(INT(ROUND(D1,2)*100)-INT(ROUND(D1,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(D1,2)*10)-INT(ROUND(D1,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(D1,2)*100)-INT(ROUND(D1,2)*10)*10)=0,"整",TEXT((INT(ROUND(D1,2)*100)-INT(ROUND(D1,2)*10)*10),"[dbnum2]")&"
分")))
附 注——
,、实际运用时只需将该公式(红色显示部分)复制并粘贴到需要的EXCEL文档中的单元格中即可。
,、公式中的单元格是可以改动的,如需改动,
方法
快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载
有二:?在A1的上边和左边插入需要数量的行数和列数单元格。此种方法适于文件初建之时。?如果需要输入小写数字的单元格已经确定,只需要另行加入该公式,则先确定输入大写的单元位置,先将上述内容复制并粘贴到该处单元格,然后更改公式中的13处的A1为需要输入小写数字的单元格。