在excel中,函数的嵌套不能超过多少级qian EXCEL中如何解决IF函数嵌套不能超过8层数的问题
Excel\u7684\u516c\u5f0f\u4e2d\u6700\u591a\u53ef\u4ee5\u5305\u542b\u51e0\u7ea7\u5d4c\u5957\u51fd\u65707.\u7ea7\u5d4c\u5957\u51fd\u6570
\u7528\u81ea\u5b9a\u4e49\u51fd\u6570\u3002ATL+F11\uff0c\u63d2\u5165\u6a21\u5757\uff0c\u628a\u4ee3\u7801\u7c98\u8fdb\u53bb
Public Function fx(x As Range)
Select Case x
Case "\u8d75"
fx = "ZHAO" & [C1] & "-" & [D1]
Case "\u51af"
fx = "FENG" & [C1] & "-" & [D1]
case "\u738b"
(\u8fd9\u91cc\u53ef\u53c2\u7167\u4e0a\u9762\u7684\u6837\u5f0f\uff0c\u81ea\u5df2\u5199\u5176\u5b83\u6761\u4ef6\uff0cN\u4e2a\u90fd\u884c)
End Select
\u7136\u540e\u8fd4\u56deEXCEL\u4e2d\uff0c=fx(a1) \u5c31\u53ef\u4ee5\u7528\u4e86
End Function
具体要看你用的是什么版本的EXCEL。EXCEL2003版本及之前(文件名后缀 XLS)函数嵌套最多为7层,EXCEL2007及之后(文件后缀 XLSX)函数嵌套最多64层。
绛旓細鍦2003鍙婁互鍓嶇増鏈腑锛孖F鍑芥暟鍙互宓屽7灞傦紝鍦2007鍙婁互鍚庣増鏈腑锛屽彲浠ュ祵濂64灞傘
绛旓細End Select 鐒跺悗杩斿洖EXCEL涓紝=fx(a1) 灏卞彲浠ョ敤浜 End Function
绛旓細浣犲啓鍏紡鏃舵暟鍊涓嶈兘鍔犲紩鍙枫傛彁绀烘潯浠跺お澶氭槸浣犵殑鎷彿娌℃湁鎵撴纭锛屽嚱鏁扮殑灞傛娌℃湁鍒嗘竻妤氾紝绋嬪簭鏃犳硶鏄庣櫧浣犺瀹炵幇鍜岃绠椾粈涔堢粨鏋溿備綘鐨勫崟鍏冩牸搴斿綋杩欐牱鍐欎笁閲岻F宓屽=IF(OR(A1=1,A1=3,A1=5),"X",IF(OR(A1=2,A1=4,A1=6),"Y",IF(AND(A1=7,OR(B1="a",B1="b",B1="c")),"Z","浠绘剰...
绛旓細鍑芥暟闂村彲浠ュ祵濂銆傛墍浠ワ紝绛旀鏄滈敊璇濄
绛旓細if鏈澶7灞傦紝褰撶劧涔熸湁鍔炴硶瑙e喅锛屼絾鏄病蹇呰闈炵敤if鍋氭瘮濡備綘杩欎釜鐢ㄤ笅闈㈢殑鍏紡鏇村ソ锛=LOOKUP(C64,{0,"涓嶅悎鏍";60,"鍚堟牸";70,"涓瓑";80,"浼樿壇";90,"浼樼";100,"瀹岀編";100.01,"浣滃紛"})
绛旓細Excel涓if鍑芥暟宓屽涔熷氨鏄湪If鍑芥暟涓繑鍥炵殑涓や釜鍊间腑浠绘剰涓涓垨涓や釜涓啀鍔犲叆涓涓敋鑷冲涓猧f鍑芥暟銆傝蒋浠剁増鏈細Office2007 涓句緥璇存槑濡備笅锛1.鍒╃敤if鍑芥暟宓屽瀹炵幇A鍊间负1鏃讹紝B杩斿洖涓锛2鏃惰繑鍥炰簩锛屽叾浠栧艰繑鍥炲叾浠栵細2.杈撳叆鍏紡濡備笅锛氬叕寮忔槸浜屽眰宓屽锛鍦ㄧ涓変釜鍙傛暟涓張鍔犲叆浜嗕竴涓狪f鍑芥暟 3.涓嬫媺濉厖寰楀埌缁撴灉锛...
绛旓細if鍑芥暟3涓潯浠宓屽鍏紡IF鏄竴涓狤xcel 閲岄潰鐨勪竴涓昏緫鍑芥暟锛屼綘鍙互if鍑芥暟鎬庝箞璁剧疆3涓潯浠跺叕寮忓苟璁$畻-鑺濆+鍥炵瓟3銆佸綋鏉′欢A2>=90涓嶆垚绔嬫椂锛岃繑鍥炰笅涓涓潯浠讹細褰撳垎鏁颁负80-89鍒嗘椂锛岃瘎瀹氱骇鍒负锛欱锛岃繖鏃堕渶瑕佸祵濂桰F鍑芥暟锛屾墠鑳借緭鍏6銆佸叕寮忚缃畬鎴愬悗鎸夊洖杞﹂敭杩斿洖B2鍗曞厓鏍艰绠楃粨鏋溿鍦╡xcel涓濡備綍杩涜澶氭if宓屽...
绛旓細IF鍑芥暟鍏佽宓屽浣跨敤锛屼絾鏈夊祵濂楀眰绾ч檺鍒躲
绛旓細2003鍑芥暟宓屽鏈澶氫竷灞傘傛ゼ涓荤殑鍏紡绱禈浜嗐傚叾瀹炵瓑鍚屼簬锛=IF(G2<20000,0,IF(OR(C2="浣忓畢",C2="闈炰綇瀹"),G2*0.015*F2,"/"))褰撶劧锛屽鏋滐紝鍓嶉潰鐨勯偅浜0鍙槸妯℃嫙鏁版嵁锛屽疄闄呭悇涓嶇浉鍚岋紝閭e氨鍙﹀綋鍒浜嗐傝繖绉嶆儏鍐典笅锛屽缓璁涓灞傚垽鏂敤C2锛岀劧鍚庡湪绗簩灞傜敤Lookup鍑芥暟灏咷2钀藉叆鐨勮寖鍥寸敤搴忓垪{0,1000...
绛旓細浣犺鐨勨滃彲浠ョ敤鈥&鈥濊繛鎺ュ涓7閲宓屽鐨刬f鍑芥暟銆傚锛=if(if(if(鈥︹︾渷鐣)))&if(if(if(鈥︹︾渷鐣)))杩欎釜鏂规硶鎴戣繑鍥炵殑缁撴灉鏄"455FALSE"鏄粈涔堝師鍥狅紝鎴戠殑鍏紡涓=IF(F7="褰╃數",IF(J7<3500,J7*0.13,455),IF(F7="鍐扮",IF(J7<2500,J7*0.13,325),IF(F7="鎵嬫満",IF(J7<100,J7*0.13...