【#文档大全网# 导语】以下是®文档大全网的小编为您整理的《小数转金额大写》，欢迎阅读！
数字小写转成大写公式(完美版)
="合 计:(大写)"&IF(INT(A2)/10=INT(INT(A2)/10),IF(ROUND(A2,2)>=1,IF(OR(A2=INT(A2),ROUND(A2,2)=1),TEXT(INT(ROUND(A2,2)),"[DBNum2]G/通用格式")&"元",IF(10*INT(A2)=INT(A2*10),TEXT(INT(ROUND(A2,2)),"[DBNum2]G/通用格式")&"元",TEXT(INT(ROUND(A2,2)),"[DBNum2]G/通用格式")&"元零")),""),IF(A2>=1,TEXT(INT(ROUND(A2,2)),"[DBNum2]G/通用格式")&"元",""))&IF(LEN(MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2))=2,IF(LEFT(MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2),1)="零",MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2)&"分",LEFT(MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2),1)&"角"&RIGHT(MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2),1)&"分"),IF(LEN(MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2))=1,MID(TEXT(ROUND(IF(A2>=1,A2-INT(A2),A2),2),"[DBNum2]G/通用格式"),3,2)&"角整",IF(ROUND(A2,2)<>0,"整","金额为零")))
2022-03-04
