数字小写转成大写公式(完美版)
="合 计:(大写)"&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,"整","金额为零")))
本文来源：https://www.wddqw.com/doc/a8c9b14b0912a21615792927.html
正在阅读：
小数转金额大写01-01
系统的逻辑:卢曼理论中几个核心概念的演变01-01
信任的近义词是什么信任的近义词01-01
反恐防暴宣传标语01-01
春节生活随笔作文五百字01-01
有关春天的古诗集锦：鸟鸣涧.doc01-01
古诗文《芙蓉楼送辛渐》赏析01-01
马耳他蓝玫瑰花语01-01
通用古风唯美句子合集38句01-01