在EXCEL表中输入小写金额后在另一行如何自动生成大写金额？
1、打开excel表格在A1单元格内输入需要转换成大写金额的数字“2205576”。
2、然后在B1单元格内点击“fx”插入函数，使用IF函数和SUBSTITUTE函数的组合。
3、在其中输入函数参数，下图为转换的公式：=IF(A1>=1,NUMBERSTRING(INT(A1),2)&"元",)&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1),2),"[dbnum2]0角0分;;整"),"零角",IF(A1<1,,"零")),"零分","整")。
4、点击回车键即可生成公式的计算结果“捌佰柒拾玖元整”。
绛旓細濡傛灉鐢ㄥ嚱鏁扮殑璇濇瘮杈冮夯鐑︿笉杩EXCEL鏈韩灏辨彁渚涘揩鎹风殑鏂瑰紡閫変腑鏍煎紡--鍗曞厓鏍--鏁板瓧涓殑鈥滅壒娈娾--鈥滀腑鏂囧ぇ鍐欌濈劧鍚庡湪B1涓緭鍏锛氾紳A1杩欐牱浣犲湪A1涓緭鍏ユ暟瀛楋紝B1灏辩珛鍒昏浆鎹㈡垚澶у啓鏁板瓧銆
绛旓細鍦‥xcel琛ㄦ牸涓鎶灏忓啓閲戦杞崲鎴愬ぇ鍐欓噾棰濈殑鏂规硶鏈変笁绉嶏細鏂规硶涓锛氶氳繃璁剧疆鍗曞厓鏍兼牸寮忓疄鐜般傛楠ゅ涓嬶細鎵撳紑Excel琛ㄦ牸锛岄変腑闇瑕佽浆鎹㈢殑鏁板瓧鍗曞厓鏍笺傚湪榧犳爣鍙抽敭鐐瑰嚮寮瑰嚭鐨勮彍鍗曚腑閫夋嫨鈥滆缃崟鍏冩牸鏍煎紡鈥濄傚湪璁剧疆鍗曞厓鏍兼牸寮忕殑鐣岄潰涓紝閫夋嫨鏁板瓧閫夐」鍗′笅鐨勨滅壒娈娾濓紝鍐嶉夋嫨鈥滀腑鏂囧ぇ鍐欐暟瀛椻濆嵆鍙傛柟娉曚簩锛氫娇鐢ㄥ叕寮忔硶瀹炵幇...
绛旓細1銆佸彸閿偣鍑婚』鐢熸垚澶у啓鐨勫崟鍏冩牸锛岄夋嫨鈥滆缃崟鍏冩牸鏍煎紡鈥濓紝鍦ㄢ滄暟瀛椻濋夐」鍗閲閫夋嫨鈥滅壒娈娾濓紝鍙宠竟鐨勭被鍨嬮噷閫夆滀腑鏂囧ぇ鍐欐暟瀛椻濓紝纭畾銆2銆侀』鐢熸垚澶у啓鐨勫崟鍏冩牸杈撳叆锛=锛岀劧鍚庡皢榧犳爣鐐瑰埌鏈灏忓啓鏁板瓧鐨勫崟鍏冩牸锛屽洖杞︺傚畬鎴愩傚彧瑕佸皬鍐欐暟瀛楀崟鍏冩牸鍙戠敓鍙樺寲锛屽ぇ鍐欏崟鍏冩牸灏变細鐩稿簲鍙樺寲銆傛晥鏋滃鍥俱
绛旓細A1涓緭鍏鏁版嵁锛孊1涓緭鍏ヤ笅闈㈢殑鍏紡锛屽洖杞﹀氨鍙互浜 =SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"璐")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/閫氱敤鏍煎紡鍏;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0瑙0鍒;;"&IF(ABS(A1)>1%,"鏁",)),"闆惰",IF(ABS(A1)<1,,"闆")),"闆跺垎",...
绛旓細鍋囧杈撳叆鐨灏忓啓閲戦鍦ˋ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*...
绛旓細A1鍗曞厓鏍间负灏忓啓鏁板煎緟姹 鍦ㄩ渶瑕佽浆鎹㈢殑鏍煎紡璁剧疆鍏紡锛屽叕寮忎负锛=IF(a1=0,"",TEXT(a1,"[dbnum2]")&"鍏冩暣")鍙﹀锛excel 杩樻彁渚涗簡涓涓殣钘忕殑杞崲涓枃鏁板瓧鐨勫嚱鏁扳斺擭UMBERSTRING鍑芥暟锛岃鍑芥暟鍚屾牱鍙互瀹炵幇涓婇潰杞崲銆=if(a1=0,"",numberstring(a1,2)&"鍏冩暣")涓嶈鍏冩暣锛氬叕寮忎竴锛=IF(a1=0,"",...
绛旓細濡傛灉浣杈撳叆鐨閲戦鏁板间粠a1寮濮嬶紝鎯宠澶у啓閲戦鍦╞鍒梑1寮濮嬫樉绀恒傞偅涔堝氨鍦╞1鍗曞厓鏍艰緭鍏ュ叕寮 =IF(a1<0,"璐",)&TEXT(TRUNC(ABS(a1)),"[DBNum2]G/閫氱敤鏍煎紡")&"鍏"&IF(ROUND(a1,3)=ROUND(a1,),"鏁",TEXT(RIGHT(TRUNC(a1*10),1),"[DBNum2]G/閫氱敤鏍煎紡")&"瑙"&IF(ROUND(a1,3)=ROUND(...
绛旓細鍋囧浣犻渶瑕佸湪鍒桝閲岃緭鍏ュ皬鍐欓噾棰鍦ㄥ垪B閲屽嚭鐜板ぇ鍐欓噾棰濓細閫変腑B1=A1鍥炶溅 鐒跺悗鍙抽敭B1---璁剧疆鍗曞厓鏍煎紡---鏁板瓧---鐗规畩---涓枃澶у啓鏁板瓧---纭畾 鐒跺悗鎶婇紶鏍囨斁鍒癇1鍗曞厓鏍肩殑鍙充笅瑙掞紝褰撻紶鏍囧彉鎴愬疄蹇冪殑榛戣壊鐨勫崄瀛楁灦鐨勬椂鍊欏線涓嬫媺銆傜劧鍚庝綘鍦ˋ鍒楅噷杈撳叆鏁板瓧鐨勬椂鍊橞鍒楄嚜鍔ㄥ彉鎴愬ぇ鍐欍
绛旓細鐢ㄩ紶鏍囧皢鎵鏈灏忓啓閲戦鎵鍦ㄧ殑鍗曞厓鏍奸変腑锛岀劧鍚庡彸鍑昏閫変腑鐨勫崟鍏冩牸锛岀偣鍑烩滀粠涓嬫媺鍒楄〃涓閫夋嫨...鈥濇寜閽細2銆佸湪鎵撳紑鐨勫崟鍏冩牸鏍煎紡璁剧疆绐楀彛涓紝鐐瑰嚮鍒嗙被涓嬮潰鐨勨滅壒娈娾濇寜閽紝鐒跺悗鐐瑰嚮绫诲瀷閲岄潰鐨勨滀腑鏂囧ぇ鍐欐暟瀛椻濇寜閽細3銆佽缃畬鎴愬悗锛岃繖鏃舵墍鏈夌殑灏忓啓閲戦閮戒細杞崲鎴愬ぇ鍐欓噾棰濓紝鐒跺悗灏Excel鏂囨。杩涜淇濆瓨鍗冲彲锛...
绛旓細A1,2)*100)-INT(ROUND(A1,2)*10)*10),"[dbnum2]")&"鍒")))璇存槑锛1銆佺敤灏忓啓鏁板瓧鎵鍦ㄧ殑鍗曞厓鏍兼浛鎹㈠叕寮忎腑鐨凙1 2銆佸鏋滃ぇ鍐閲戦鍚庨潰涓嶉渶瑕佸啋鍙凤紝鎴栬呴渶瑕佽嫳鏂囩姸鎬佺殑鍐掑彿锛岃嚜宸变慨鏀瑰叕寮忎腑鐨勫啋鍙峰嵆鍙 3銆佸鏋滈噾棰濅腑鏈夊垎锛屾寜鐓т功鍐欎範鎯笉闇瑕佹渶鍚庣殑鏁村瓧锛屽洜姝わ紝闄や繚鐣欏埌鍒嗙殑鏁板瓧澶栧叏閮ㄧ暀鏁淬
