电脑if函数怎么可以把小写金额变大写 excel if 函数不能区分大小写
excel:\u963f\u62c9\u4f2f\u6570\u5b57\u8f6c\u5316\u4e3a\u91d1\u989d\u5927\u5199\u4ed8\u6b3e\u91d1\u989d:"¥123,456,789.12"
\u5927\u5199:\u58f9\u4ebf\u8d30\u4edf\u53c1\u4f70\u8086\u62fe\u4f0d\u4e07\u9646\u4edf\u67d2\u4f70\u634c\u62fe\u7396\u5143\u58f9\u89d2\u8d30\u5206
\u5355\u5143\u683cB6\u51fd\u6570\u7f16\u8f91\u5982\u4e0b\uff1a
" =IF(ROUND(B6,2)<0,""\u65e0\u6548\u6570\u503c"",IF(ROUND(B6,2)=0,""\u96f6"",IF(ROUND(B6,2)<1,"""",TEXT(INT(ROUND(B6,2)),""[dbnum2]"")&""\u5143"")&IF(INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10=0,IF(INT(ROUND(B6,2))*(INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10)=0,"""",""\u96f6""),TEXT(INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10,""[dbnum2]"")&""\u89d2"")&IF((INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10)=0,""\u6574"",TEXT((INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10),""[dbnum2]"")&""\u5206"")))"
\u51fd\u6570\u5e94\u7528\u5206\u6790\uff1a
\u4e00\u3001ROUND\uff0c\u6570\u5b66\u548c\u4e09\u89d2\u51fd\u6570\uff1a\u5c06\u6570\u5b57\u6309\u6307\u5b9a\u4f4d\u6570\u820d\u5165
" (ROUND(B6,2)\uff0c\u5373\u5bf9\u5355\u5143\u683cB6\u7684\u5185\u5bb9\u8fdb\u884c\u56db\u820d\u4e94\u5165\u5904\u7406\uff0c\u4e14\u4fdd\u7559\u4e24\u4f4d\u5c0f\u6570"
\u4e8c\u3001INT\uff0c\u6570\u5b66\u548c\u4e09\u89d2\u51fd\u6570\uff1a\u5c06\u6570\u5b57\u5411\u4e0b\u820d\u5165\u5230\u6700\u63a5\u8fd1\u7684\u6574\u6570
" INT(ROUND(B6,2)\uff0c\u5373\u5bf9\u5355\u5143\u683cB6\u5728\u8fdb\u884c\u56db\u820d\u4e94\u5165\u4fdd\u7559\u4e24\u4f4d\u5c0f\u6570\u7684\u57fa\u7840\u4e0a\uff0c\u53bb\u6389\u5c0f\u6570\u70b9\u540e\u9762\u7684\u4f4d\u6570\uff0c\u5373\u53ea\u663e\u793a\u6574\u6570\uff0c\u6b64\u65f6\uff0cINT(ROUND(B6,2)\u548cINT\uff08B6\uff09\u6548\u679c\u662f\u4e00\u6837\u7684\u3002"
\u4e09\u3001TEXT\uff0c\u6587\u672c\u51fd\u6570\uff1a\u8bbe\u7f6e\u6570\u5b57\u683c\u5f0f\u5e76\u5c06\u5176\u8f6c\u6362\u4e3a\u6587\u672c\uff1b[dbnum2]\uff0c\u683c\u5f0f\u51fd\u6570
" TEXT(INT(ROUND(B6,2)),""[dbnum2]"")\uff0c\u5373\u5bf9INT(ROUND(B6,2))\u4ee5[dbnum2]\u683c\u5f0f\u8fdb\u884c\u663e\u793a\u3002"
[dbnum2]\uff0c\u4e3a\u5355\u5143\u683c\u683c\u5f0f\u4ee3\u7801\uff08\u4ea6\u53ef\u79f0\u4e4b\u4e3a\u683c\u5f0f\u51fd\u6570\uff09\uff0c\u683c\u5f0f\u63cf\u8ff0\u4e3a\uff1a\u4e2d\u6587\u5927\u5199\u6570\u5b57\uff0c\u66f4\u591a\u5355\u5143\u683c\u683c\u5f0f\u4ee3\u7801\uff0c\u8bf7\u70b9\u51fb\u67e5\u8be2
\u56db\u3001&\uff0c\u6587\u672c\u8fde\u63a5\u7b26\uff0c\u6709\u5408\u5e76\u5355\u5143\u683c\u5185\u5bb9\u7684\u529f\u80fd\uff0c\u8fd0\u7528\u5728\u51fd\u6570\u516c\u5f0f\u4e2d\uff0c\u8d77\u5230\u8fde\u63a5\u6587\u672c\uff08\u6216\u662f\u6570\u5b57\uff09\u5185\u5bb9\u7684\u4f5c\u7528\u3002
" TEXT(INT(ROUND(B6,2)),""[dbnum2]"")&""\u5143""\uff0c\u5373\u5c06\u6570\u5b57\u6309\u8981\u6c42\u8f6c\u5316\u4e3a\u4e2d\u6587\u5927\u5199\u540e\u52a0\u201c\u5143\u201d\uff0c\u5b8c\u6210\u5355\u5143\u683cB6\u201c\u5143\u201d\u5355\u4f4d\u8bbe\u7f6e\u3002"
\u4e94\u3001IF\u6761\u4ef6\u51fd\u6570\u3001IF\u5d4c\u5957\u51fd\u6570\u3001\u7ec4\u5408\u51fd\u6570\u5e94\u7528\uff1a
"\u7b2c\u4e00\u5c42\u6761\u4ef6\u51fd\u6570\u4e3a\uff1a\u5982\u679c(ROUND(B6,2)<0,\u5219\u5355\u5143\u683cB6\u663e\u793a\u7ed3\u679c\u4e3a\u201c\u65e0\u6548\u6570\u503c\u201d\uff0c\u5426\u5219\u2026\u2026(\u4ee5\u7b2c\u4e8c\u5c42\u6761\u4ef6\u51fd\u6570\u8868\u8fbe\uff09"
"\u7b2c\u4e8c\u5c42\u6761\u4ef6\u51fd\u6570\u4e3a\uff1a\u5982\u679c(ROUND(B6,2)=0,\u5219\u5355\u5143\u683cB6\u663e\u793a\u7ed3\u679c\u4e3a\u201c\u96f6\u201d\uff0c\u5426\u5219\u2026\u2026(\u4ee5&\u8fde\u63a5IF\u6761\u4ef6\u51fd\u6570\u8868\u8fbe\uff09"
\u7b2c\u4e09\u5c42\u6761\u4ef6\u51fd\u6570\u4e3a\uff1a\u5d4c\u5957\u7ec4\u5408\u51fd\u6570\uff0c\u7ed3\u6784\u4e3a\uff1aIF***&\u5143IF***&\u89d2&IF***\u5206
"A\u3001\u201c\u5143\u201d\u4f4d\u6570\u636e\u7684\u8bfb\u53d6\uff1aIF(ROUND(B6,2)<1,"""",TEXT(INT(ROUND(B6,2)),""[dbnum2]"")&""\u5143"")"
\u8bfb\u53d6\u4e2a\u4f4d\u6570\u4ee5\u4e0a\u7684\u6570\u636e\uff0c\u4ee5\u201c\u5143\u201d\u7ed3\u675f\uff0c\u5982\u679c\u5c0f\u4e8e1\uff0c\u5219\u4e0d\u5fc5\u663e\u793a\u4ec0\u4e48\u5185\u5bb9
"B\u3001\u201c\u89d2\u201d\u4f4d\u6570\u636e\u7684\u8bfb\u53d6\uff1aIF(INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10=0,IF(INT(ROUND(B6,2))*(INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10)=0,"""",""\u96f6""),TEXT(INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10,""[dbnum2]"")&""\u89d2"")"
" \u7b2c1\u5c42\uff1a\u5982\u679c\u5355\u5143\u683cB6\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u4e3a0\uff0c\u5219\u2026\u2026(\u4ee5\u7b2c2\u5c42\u6761\u4ef6\u51fd\u6570\u8868\u8fbe),\u5426\u5219\uff0c\u8ba1\u7b97\u4e3a
\u201cTEXT(INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10,""[dbnum2]"")&""\u89d2""\u201d"
" \u7b2c2\u5c42\uff1a\u5728\u5c0f\u6570\u70b9\u540e\u7b2c\u4e8c\u4f4d\uff08\u672b\u4f4d\u6570\uff09\u4e3a0\u7684\u60c5\u51b5\u4e0b\uff0c\u5bf9\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u6570\u5b57\u8ba1\u7b97\u4e3a"""",\u5373\u4e0d\u8bfb\u53d6\u89d2\u4f4d\u6570\u636e\uff0c\u5426\u5219\uff08\u672b\u4f4d\u6570\u4e0d\u4e3a0\u7684\u60c5\u51b5\uff09\uff0c
\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u8bfb\u53d6\u4e3a\u201c\u96f6\u201d\uff1b"
"C\u3001\u201c\u5206\u201d\u4f4d\u6570\u636e\u7684\u8bfb\u53d6\uff1aIF((INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10)=0,""\u6574""\uff0cTEXT((INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10),""[dbnum2]"")&""\u5206"")))"
\u5982\u679c\u5355\u5143\u683cB6\u672b\u4f4d\u6570\u4e3a0\uff0c\u5219\u4ee5\u201c\u6574\u201d\u7ed3\u675f\uff0c\u800c\u5219\u5c31\u4ee5\u201c\u5206\u201d\u7ed3\u675f\uff1b
\u516d\u3001\u516c\u5f0f\u5e94\u7528\u8bf4\u660e\uff1a
"INT(ROUND(B6,2)*10)\uff0c\u5bf9\u5355\u5143\u683cB6\u6570\u5b57\u5148\u6269\u592710\u500d\u518d\u8fdb\u884c\u820d\u4f4d\uff0c\u5373\u53bb\u6389\u5c0f\u6570\u70b9\u540e\u7684\u4f4d\u6570\uff0c\u6b64\u65f6\u4e2a\u4f4d\u6570\u4e3a\u5355\u5143\u683cB6\u6570\u636e\u7684\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u6570\u5b57\uff1b"
"INT(ROUND(B6,2))*10\uff0c\u5bf9\u5355\u5143\u683cB6\u6570\u5b57\u5148\u53bb\u6389\u5c0f\u6570\u70b9\u540e\u7684\u4f4d\u6570\uff0c\u518d\u6269\u592710\u500d\uff0c\u6b64\u65f6\uff0c\u4e2a\u4f4d\u6570\u4e3a\u96f6\uff1b"
"INT(ROUND(B6,2)*10)-INT(ROUND(B6,2))*10=0\uff0c\u8bf4\u660e\u5355\u5143\u683cB6\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u4e3a\u201c\u96f6\u201d\uff0c\u5426\u5219\u7ed3\u679c\u5c31\u662f\u5355\u5143\u683cB6\u5c0f\u6570\u70b9\u540e\u7b2c\u4e00\u4f4d\u6570\u5b57\uff01"
"INT(ROUND(B6,2)*100)\uff0c\u5bf9\u5355\u5143\u683cB6\u6570\u5b57\u5148\u6269\u5927100\u500d\u518d\u8fdb\u884c\u820d\u4f4d\uff0c\u5373\u53bb\u6389\u5c0f\u6570\u70b9\u540e\u7684\u4f4d\u6570\uff0c\u6b64\u65f6\u4e2a\u4f4d\u6570\u4e3a\u5355\u5143\u683cB6\u6570\u636e\u7684\u5c0f\u6570\u70b9\u540e\u7b2c\u4e8c\u4f4d\u6570\u5b57\uff08\u4ea6\u5373\u672b\u4f4d\u6570\uff09"
"INT(ROUND(B6,2)*10)*10\uff0c\u5bf9\u5355\u5143\u683cB6\u6570\u5b57\u5148\u6269\u592710\u500d\u518d\u820d\u4f4d\uff0c\u540c\u65f6\u518d\u6269\u592710\u500d\uff0c\u5373\u5c06\u5355\u5143\u683cB6\u6570\u636e\u7684\u5c0f\u6570\u70b9\u540e\u7b2c\u4e8c\u6570\uff08\u672b\u4f4d\u6570\uff09\u53bb\u6389\u540e\u6574\u4f53\u6269\u5927100\u500d"
"INT(ROUND(B6,2)*100)-INT(ROUND(B6,2)*10)*10=0\uff0c\u8bf4\u660e\u5355\u5143\u683cB6\u5c0f\u6570\u70b9\u540e\u7b2c\u4e8c\u4f4d\u4e3a\u201c\u96f6\u201d\uff0c\u5426\u5219\u7ed3\u679c\u5c31\u662f\u5355\u5143\u683cB6\u5c0f\u6570\u70b9\u540e\u7b2c\u4e8c\u4f4d\u6570\u5b57\uff01"
Excel\u7684IF\u51fd\u6570\u5224\u65ad\u4e2d\u6587\u6761\u4ef6\u65f6\u6587\u5b57\u4e0a\u52a0\u53cc\u5f15\u53f7\u5373\u53ef\u3002
Excel\u7684IF\u51fd\u6570\uff1a
\u3000\u3000IF\u51fd\u6570\u4e00\u822c\u662f\u6307Excel\u4e2d\u7684IF\u51fd\u6570\uff0c\u6839\u636e\u6307\u5b9a\u7684\u6761\u4ef6\u6765\u5224\u65ad\u5176\u201c\u771f\u201d\uff08TRUE\uff09\u3001\u201c\u5047\u201d\uff08FALSE\uff09\uff0c\u6839\u636e\u903b\u8f91\u8ba1\u7b97\u7684\u771f\u5047\u503c\uff0c\u4ece\u800c\u8fd4\u56de\u76f8\u5e94\u7684\u5185\u5bb9\u3002\u53ef\u4ee5\u4f7f\u7528\u51fd\u6570 IF \u5bf9\u6570\u503c\u548c\u516c\u5f0f\u8fdb\u884c\u6761\u4ef6\u68c0\u6d4b\u3002
\u3000\u3000\u8bed\u6cd5\uff1a
\u3000\u3000IF(logical_test,value_if_true,value_if_false)
\u3000\u3000Logical_test \u8868\u793a\u8ba1\u7b97\u7ed3\u679c\u4e3a TRUE \u6216 FALSE \u7684\u4efb\u610f\u503c\u6216\u8868\u8fbe\u5f0f\u3002
\u3000\u3000\u4f8b\u5982\uff0cA10=100 \u5c31\u662f\u4e00\u4e2a\u903b\u8f91\u8868\u8fbe\u5f0f\uff0c\u5982\u679c\u5355\u5143\u683c A10 \u4e2d\u7684\u503c\u7b49\u4e8e 100\uff0c\u8868\u8fbe\u5f0f\u5373\u4e3a TRUE\uff0c\u5426\u5219\u4e3a FALSE\u3002\u672c\u53c2\u6570\u53ef\u4f7f\u7528\u4efb\u4f55\u6bd4\u8f83\u8fd0\u7b97\u7b26\uff08\u4e00\u4e2a\u6807\u8bb0\u6216\u7b26\u53f7\uff0c\u6307\u5b9a\u8868\u8fbe\u5f0f\u5185\u6267\u884c\u7684\u8ba1\u7b97\u7684\u7c7b\u578b\u3002\u6709\u6570\u5b66\u3001\u6bd4\u8f83\u3001\u903b\u8f91\u548c\u5f15\u7528\u8fd0\u7b97\u7b26\u7b49\u3002\uff09\u3002
\u3000\u3000Value_if_true logical_test \u4e3a TRUE \u65f6\u8fd4\u56de\u7684\u503c\u3002
\u3000\u3000\u4f8b\u5982\uff0c\u5982\u679c\u672c\u53c2\u6570\u4e3a\u6587\u672c\u5b57\u7b26\u4e32\u201c\u9884\u7b97\u5185\u201d\u800c\u4e14 logical_test \u53c2\u6570\u503c\u4e3a TRUE\uff0c\u5219 IF \u51fd\u6570\u5c06\u663e\u793a\u6587\u672c\u201c\u9884\u7b97\u5185\u201d\u3002\u5982\u679c logical_test \u4e3a TRUE \u800c value_if_true \u4e3a\u7a7a\uff0c\u5219\u672c\u53c2\u6570\u8fd4\u56de 0\uff08\u96f6\uff09\u3002\u5982\u679c\u8981\u663e\u793a TRUE\uff0c\u5219\u8bf7\u4e3a\u672c\u53c2\u6570\u4f7f\u7528\u903b\u8f91\u503c TRUE\u3002value_if_true \u4e5f\u53ef\u4ee5\u662f\u5176\u4ed6\u516c\u5f0f\u3002
\u3000\u3000Value_if_false logical_test \u4e3a FALSE \u65f6\u8fd4\u56de\u7684\u503c\u3002
\u3000\u3000\u4f8b\u5982\uff0c\u5982\u679c\u672c\u53c2\u6570\u4e3a\u6587\u672c\u5b57\u7b26\u4e32\u201c\u8d85\u51fa\u9884\u7b97\u201d\u800c\u4e14 logical_test \u53c2\u6570\u503c\u4e3a FALSE\uff0c\u5219 IF \u51fd\u6570\u5c06\u663e\u793a\u6587\u672c\u201c\u8d85\u51fa\u9884\u7b97\u201d\u3002\u5982\u679c logical_test \u4e3a FALSE \u4e14\u5ffd\u7565\u4e86 value_if_false\uff08\u5373 value_if_true \u540e\u6ca1\u6709\u9017\u53f7\uff09\uff0c\u5219\u4f1a\u8fd4\u56de\u903b\u8f91\u503c FALSE\u3002\u5982\u679c logical_test \u4e3a FALSE \u4e14 value_if_false \u4e3a\u7a7a\uff08\u5373 value_if_true \u540e\u6709\u9017\u53f7\uff0c\u5e76\u7d27\u8ddf\u7740\u53f3\u62ec\u53f7\uff09\uff0c\u5219\u672c\u53c2\u6570\u8fd4\u56de 0\uff08\u96f6\uff09\u3002VALUE_if_false \u4e5f\u53ef\u4ee5\u662f\u5176\u4ed6\u516c\u5f0f\u3002
设置单元格格式，数字，特殊，中文大写数字，这样就可以了。要加一个元整，需要点了特殊之后，选中中文大写数字，然后点击自定义，会看见 [DBNum2][$-804]G/通用格式 这个时候在这句话后面加上 "元整" ，注意双引号要是英文输入状态下的双引号。假定你要在B1输入阿拉佰数字,C1转换成中文大写金额(含元角分),请在C1单元格输入如下公式: =SUBSTITUTE(SUBSTITUTE(IF(-RMB(B1),IF(B1>0,,"负")
=IF(ROUND(G8,2)<0,"无效数值",IF(ROUND(G8,2)=0,"零",IF(ROUND(G8,2)<1,"",TEXT(INT(ROUND(G8,2)),"[dbnum2]")&"元")&IF(INT(ROUND(G8,2)*10)-INT(ROUND(G8,2))*10=0,IF(INT(ROUND(G8,2))* (INT(ROUND(G8,2)*100)-INT(ROUND(G8,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(G8,2)*10)-INT(ROUND(G8,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(G8,2)*100)-INT(ROUND(G8,2)*10)*10)=0,"整",TEXT((INT(ROUND(G8,2)*100)-INT(ROUND(G8,2)*10)*10),"[dbnum2]")&"分")))
注：“G8”是 Excel 表格中金额小写所在的单元格，各人使用时只需修改下小写所在单元格位置即可。
Excel数字小写金额转换成汉字大写金额的方法_百度经验 http://jingyan.baidu.com/article/a3761b2b8774331576f9aadc.html
绛旓細1銆佹墦寮excel琛ㄦ牸鍦ˋ1鍗曞厓鏍煎唴杈撳叆闇瑕佽浆鎹㈡垚澶у啓閲戦鐨勬暟瀛椻2205576鈥濄2銆佺劧鍚庡湪B1鍗曞厓鏍煎唴鐐瑰嚮鈥渇x鈥濇彃鍏ュ嚱鏁帮紝浣跨敤IF鍑芥暟鍜孲UBSTITUTE鍑芥暟鐨缁勫悎銆3銆佸湪鍏朵腑杈撳叆鍑芥暟鍙傛暟锛屼笅鍥句负杞崲鐨勫叕寮忥細=IF(A1>=1,NUMBERSTRING(INT(A1),2)&"鍏",)&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1),2),"[dbnum2...
绛旓細鏁")璁剧疆鍗曞厓鏍兼牸寮锛屾暟瀛楋紝鐗规畩锛屼腑鏂囧ぇ鍐欐暟瀛楋紝杩欐牱灏卞彲浠ヤ簡銆傝鍔犱竴涓厓鏁达紝闇瑕佺偣浜嗙壒娈婁箣鍚庯紝閫変腑涓枃澶у啓鏁板瓧锛岀劧鍚庣偣鍑昏嚜瀹氫箟锛屼細鐪嬭 [DBNum2][$-804]G/閫氱敤鏍煎紡 杩欎釜鏃跺欏湪杩欏彞璇濆悗闈㈠姞涓 "鍏冩暣" 锛屾敞鎰忓弻寮曞彿瑕佹槸鑻辨枃杈撳叆鐘舵佷笅鐨勫弻寮曞彿銆傚亣瀹氫綘瑕佸湪B1杈撳叆闃挎媺浣版暟瀛,C1杞崲鎴愪腑鏂囧ぇ鍐...
绛旓細鍏堝皢闇瑕佸～鍐欏ぇ鍐欐暟瀛楃殑鍗曞厓鏍艰缃牸寮忎负鈥滅壒娈---澶у啓鏁板瓧鈥濄傜劧鍚庣敤if鍑芥暟鏉ュ疄鐜锛屽鍥撅紝鍏堝垽鏂涓涓皬鍐欐暟瀛楁槸涓嶆槸0锛屽叕寮忊=IF(B2=0,"⊗",B2)鈥濄傜劧鍚庝粠绗簩涓崟鍏冩牸璧凤紝涓嶄絾闇瑕佸垽鏂皬鍐欐暟瀛楁槸涓嶆槸0锛岃繕闇瑕佸垽鏂墠涓涓崟鍏冩牸鏄笉鏄⊗锛屽叕寮忥細鈥=IF(AND(C2=0,B3="⊗...
绛旓細涓婂浘鍙互鐪嬪嚭锛孨UMBERSTRING鍑芥暟杞崲鏁堟灉鍩烘湰鍚岃缃鍗曞厓鏍兼牸寮娉曪紝浠呰兘杞崲姝ｆ暣鏁 锛屽湪閬囧埌璐熸暟鐨勬椂鍊欎細鐩存帴鎶ラ敊锛屽皬鏁板垯鐩存帴鎴柇锛屼笉杩涜杞崲銆傛柟娉曚笁 鍏紡娉 B2鍗曞厓鏍艰緭鍏ヤ互涓嬪叕寮忥細=IF(A20,"璐","")IF(TRUNC(A2)=A2,TEXT(IF(A20,-A2,A2),"")"鍏冩暣",IF(TRUNC(A2*10)=A2*10,TEXT(TRUNC(I...
绛旓細EXCEL涓暟瀛灏忓啓鎹㈠ぇ鍐欐柟娉曚竴锛氬湪鍗曞厓鏍糀2涓緭鍏ュ皬鍐欐暟瀛123.12 B2澶勮緭鍏ヤ互涓嬪叕寮 =SUBSTITUTE(SUBSTITUTE(IF(A2<0,"璐","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"鍏"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(...
绛旓細鍋囧杈撳叆鐨勫皬鍐欓噾棰鍦ˋ1鍗曞厓鏍硷紝鍏紡锛=IF(A1=0,"",IF(INT(A1),TEXT(TRUNC(A1),"[dbnum2]")&"鍏","")&IF(MOD(A1,1)=0,"鏁",IF(TRUNC(A1,1),IF(A1=TRUNC(A1,1),TEXT(LEFT(RIGHT(A1*100,2)),"[dbnum2]0瑙掓暣"),TEXT(RIGHT(A1*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(A1*...
绛旓細濡傚浘渚嬶紝鏁板瓧閲戦鎵鍦ㄤ綅缃负P2銆備竾浣嶅叕寮忥細=IF(INT($P$2/10000)=0,"脳",MID("澹硅窗鍙佽倖浼嶉檰鏌掓崒鐜",INT($P$2/10000),1))鍗冧綅锛=IF((INT($P$2/1000)-INT($P$2/10000)*10)=0,"脳",MID("澹硅窗鍙佽倖浼嶉檰鏌掓崒鐜",(INT($P$2/1000)-INT($P$2/10000)*10),1))鐧句綅锛=IF((...
绛旓細璁剧疆鍗曞厓鏍兼牸寮 鍦ㄥ崟鍏冩牸鏍煎紡瀵硅瘽妗 鐐硅嚜瀹氫箟 鐒跺悗鍦 绫诲瀷 閲岃緭鍏 [DBNum2]0"浜"0"涓"0"浠"0"浣"0"鎷"0"鍏"0"瑙"0"鍒"杩欎釜鏁板 涓綅 鏄 鍒 濡傛灉涓嶇敤鍒嗕綔鍗曚綅 灏辨妸鍚庨潰鐨勫垹鎺 瑕佷笉灏辨妸浣犺杈撳叆鐨勬暟 鎵╁ぇ100鍊
绛旓細1銆佹紨绀轰娇鐢ㄧ殑杞欢涓篍xcel鐢靛瓙琛ㄦ牸锛屼娇鐢ㄧ殑鐗堟湰涓簅ffice professional plus2013銆2銆侀鍏堟墦寮鐢靛瓙琛ㄦ牸骞跺湪琛ㄦ牸涓緭鍏ョ敤浜庢紨绀哄浣曞湪杈撳叆灏忓啓閲戦鍚庯紝鑷姩鐢熸垚澶у啓閲戦鐨勬搷浣滄墍闇瑕佺殑鏁版嵁銆3銆侀変腑鎯宠鐢熸垚澶у啓閲戦鐨勫垪锛屽苟鍗曞嚮鍙抽敭閫夋嫨璁剧疆鍗曞厓鏍兼牸寮鑿滃崟锛屽湪寮瑰嚭鐨勭獥鍙ｄ腑灏嗘牸寮忚缃负鐗规畩涓枃澶у啓鏁板瓧骞剁偣鍑荤‘瀹氥
绛旓細鍔犱竴涓IF鍑芥暟 =IF(A7="","",LEFT(RIGHT(" ¥"&$A7*100,11-COLUMN(A:A)),1))濡傛灉A7绛変簬绌哄硷紝閭ｄ箞杩斿洖缁撴灉涓虹┖鍊笺
