濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細
Excel涓璅IND鍑芥暟鐢ㄥ湪鏁板€兼煡鎵句笂锛岀敓鎴愭煡鎵剧殑绱㈠紩
VLOOKUP銆丼UMIFS杩欓兘鏄潪甯稿父瑙勭殑鏂规硶锛屼粖澶╄浠嬬粛鐨勬槸涓€绉嶅紑闃旇閲庣殑涓€绉嶅鐞嗘柟娉曪紝鐔熸倝瀛楃涓插鐞嗙殑鍚屽锛岃偗瀹氫簡瑙IND鍑芥暟锛欶IND鍑芥暟鍙互鍦ㄤ竴涓瓧绗︿覆涓壘鍒版寚瀹氬瓧绗︾殑浣嶇疆銆�
鎴戜滑灏辨牴鎹繖涓壒鐐规潵鍐欎竴涓叕寮忥細
Excel涓璅IND鍑芥暟鐢ㄥ湪鏁板€兼煡鎵句笂锛岀敓鎴愭煡鎵剧殑绱㈠紩
=SWITCH(FIND(A2,"ABCDE"),1,500,2,400,3,300,4,200,5,100)
鍏跺疄杩欎釜鍏紡鍐欑殑鏈夌偣澶氫綑锛屽鏋滅敤SWITCH鍙兘灏变笉浼氳繖涔堝啓锛屼細杩欐牱鏉ュ啓锛�
=SWITCH(A2,"A",500,"B",400,"C",300,"D",200,"E",100)
鏇村鏄撶悊瑙c€傚弽鍊掓槸鐢–HOOSE鍑芥暟锛屽埌寰堟甯革細
=CHOOSE(FIND(A2,"ABCDE"),500,400,300,200,100)
鏈夊叴瓒e彲浠ユ祴璇曚竴涓嬶紝涓婇潰鐨勫叕寮忥紝鐪嬬湅鑳戒笉鑳藉緱鍒版兂瑕佺殑缁撴灉銆�
褰撶劧鍐欒繖涓狥IND鍑芥暟鍑烘潵涓昏鏄负浜嗚鏄庯紝閫氳繃FIND鍑芥暟鍙互鎵惧埌瀵瑰簲鐨勪綅缃紝閭d箞鎴戜滑娌跨潃杩欎釜鎬濊矾锛屽啀寤剁敵涓€鐐癸細鑳戒笉鑳介€氳繃FIND锛堬級*100鐨勬柟娉曠洿鎺ュ緱鍒扮粨鏋溿€�
Excel涓璅IND鍑芥暟鐢ㄥ湪鏁板€兼煡鎵句笂锛岀敓鎴愭煡鎵剧殑绱㈠紩
=FIND(A2,"EDCBA")*100
瀵圭殑锛屽彧瑕佹垜浠妸瀛楃涓茬殑椤哄簭棰犲€掍竴涓嬶紝灏卞彲浠ヤ簡銆�
閫氳繃浠婂ぉ杩欎釜灏忎緥瀛愬憡璇夊ぇ瀹讹紝涓€涓棶棰樼殑瑙e喅鏂规锛屾湁寰堝绉嶏紝鏈夋椂鍊欐崲涓€涓€濊矾锛屽彲鑳藉氨浼氭湁涓嶄竴鏍风殑鏂规硶鍑虹幇銆�
鏇村鏈夊叧 excel
Excel妯$硦鏌ユ壘瀛︿細杩�5涓柟娉曪紝宸ヤ綔绠€鐩村紑浜嗘寕
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-05 07:00:00- 濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-05 09:00:23
宸ヤ綔鍐嶅繖锛屼篃瑕佸浼氳繖10涓渶缁忓吀鐨凟xcel灏忔妧宸�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 05:28:51- 濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 10:07:04
- 濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 03:06:25
寰蒋闈㈠悜iOS鍜孉ndroid鎺ㄥ嚭鏂癘ffice搴旂敤 缁撳悎Word銆丒xcel鍜孭owerPoint
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 10:39:12Excel涓璅IND鍑芥暟鐢ㄥ湪鏁板€兼煡鎵句笂锛岀敓鎴愭煡鎵剧殑绱㈠紩
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 04:39:03Excel 涓父鐢ㄧ殑鍑芥暟涔嬩竴锛歷lookup鍑芥暟鐨勪娇鐢ㄦ柟娉�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 08:48:00Excel涓繀椤绘帉鎻$殑5涓揩鎹烽敭锛佹瘡涓兘寰堝疄鐢紝蹇姳鍑犲垎閽熻璧锋潵鍚�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 06:19:27骞茶揣鍏变韩锛歅DF銆乄ORD銆丳PT銆丒XCEL鏍煎紡浜掓崲锛屼竴娆℃€у叏甯綘鎼炲畾
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 05:36:21Excel濡備綍鎷嗗垎鏁版嵁锛屾帉鎻¤繖涓ょ鏂规硶锛�1鍒嗛挓鎻愬彇Excel鏂囨湰淇℃伅
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-03 05:58:08鍘熸潵Excel杞崲涓哄浘鐗囷紝鍗充娇鏇存敼琛ㄦ牸鍐呭锛屽浘鐗囦篃鑳借嚜鍔ㄦ洿鏂�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 04:01:37EXCEL鍏紡鐢ㄤ簡鍗佸勾锛屼粠涓嬪悜涓婃嫋鍔ㄥ叕寮忥紝鐢ㄦ硶鏈夌偣缁忓吀锛屽お瀹炵敤
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 03:59:26鏁寸悊6骞寸殑excel鏂囨。锛屾垜璇撮渶瑕�5灏忔椂锛屽悓浜嬪嵈璇村弻鍑讳竴涓�10绉掓悶瀹�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 11:20:00蹇敹钘忥紒鍒嗗垎閽熸彁楂樺伐浣滄晥鐜囩殑Excel灏忔妧宸�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 01:05:17涓嶄細杩欎簲涓嚱鏁帮紝鍒浣犱細Excel锛佺啛缁冩帉鎻★紝璧伴亶鑱屽満閮戒笉鎬�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 08:45:06EXCEL灏忔妧宸э細濡備綍灏咵XCEL閲岀殑琛屽彿鍜屽垪鏍囨墦鍗板嚭鏉�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-04 01:12:36Excel鏁版嵁閫忚琛ㄨ绠楋紝涓や釜鐩稿悓鐨勫唴瀹规病鏈夋眹鎬诲埌涓€鍧�
濂栭噾鍙戞斁鎸変簲涓骇鍒潵锛岃绠楁柟娉曟湁寰堝绉嶏細2019-11-03 07:39:24