Excel怎么用函数实现能力评估功能
excel\u4e2d\u600e\u4e48\u7528\u51fd\u6570\u5b9e\u73b0\u4e0b\u5217\u529f\u80fd\uff1a1\u3001CC\u5217DD\u5217EE\u5217\u8f6c\u6362\u6210FF\u5217\u7684\u503c\u516c\u5f0f\u5982\u4e0b\uff1a
=CC1&","&DD1&","&EE1\uff1b
2\u3001AA\u5217\u8f6c\u6362\u6210BB\u5217\u7684\u503c\u516c\u5f0f\u5982\u4e0b\uff1a
=IF(RIGHT(AA1,2)="uF",LEFT(AA1,LEN(AA1)-2)*1000000&"pF",IF(RIGHT(AA1,2)="nF",LEFT(AA1,LEN(AA1)-2)*1000&"pF",AA1));
\u5982\u679c\u524d\u9762\u7684\u5355\u4f4d\u53ea\u6709uF\u3001nF\u3001pF\u7684\u8bdd\uff0c\u5e94\u8be5\u6ca1\u6709\u95ee\u9898\uff0c\u5982\u679c\u8fd8\u6709\u522b\u7684\u5355\u4f4d\uff0c\u5c31\u8fd8\u8981\u6539\u516c\u53f8\uff0c
\u5e0c\u671b\u53ef\u4ee5\u5e2e\u5230\u4f60\uff01
\u5982\u56fe\uff0cAA\u5217\u7684\u6570\u636e\u653e\u5728A\u5217\uff0cBB\u5217\u6570\u636e\u653e\u5728B\u5217\uff0c\u4ee5A2\u3001B2\u4e3a\u4f8b\uff0c
B2=IF(RIGHT(A2,2)="uF",(LEFT(A2,LEN(A2)-2)*1000000)&"pF",IF(RIGHT(A2,2)="nF",(LEFT(A2,LEN(A2)-2)*1000)&"nF",A2))
\u7136\u540e\u4e0b\u62c9\u516c\u5f0f\u5373\u53ef\u3002
\u53e6\u5916\u4e00\u4e2a\uff1aFF2=CC2&"\uff0c"&DD2&"\uff0c"&FF2
=IF(SUMIF(O:O,O2,P:P)=0,"N","Y")
公式向下填充
（刚才没看清题意，现在修正了。）
绛旓細鐢‥XCEL宸ヤ綔琛ㄦ庢牱鍒╃敤IF鍑芥暟璁＄畻鍒嗘暟绛夌骇01鎵撳紑淇濆瓨鏈夊垎鏁扮殑琛ㄦ牸锛屽鍥炬墍绀恒傚湪寮瑰嚭鐨勨滄彃鍏ュ嚱鏁扳濆璇濇涓紝鍦ㄢ滄悳绱㈠嚱鏁扳濅腑杈撳叆鈥漣f鈥滐紝骞跺崟鍑烩濊浆鍒扳滄寜閽紝鍦ㄢ濋夋嫨鍑芥暟鈥滃璇濇涓変腑鈥漣f鈥滐紝鍗曞嚮鈥濈‘瀹氣滄寜閽傚湪Excel涓浣曞埄鐢IF鍑芥暟瀵瑰鐢熸垚缁╄繘琛岃瘎瀹氭鏃朵細寮瑰嚭鈥濆嚱鏁板弬鏁扳滃璇濇銆傚湪鐢佃剳涓婃墦...
绛旓細EXCEL鏉′欢鍑芥暟鏍规嵁骞冲潎鍒嗚瘎瀹氬叾绛夌骇1銆侀鍏堟墦寮闇瑕佹樉绀虹瓑绾х殑EXCEL锛屽湪琛ㄤ腑C1鍗曞厓鏍艰緭鍏ョ瓑绾э紝鐒跺悗榧犳爣鐐瑰埌C2鍗曞厓鏍肩偣鍑讳笂鏂硅彍鍗曟爮涓殑鍏紡鎻掑叆鍑芥暟锛岃涓嬪浘鎵绀猴紝璺冲嚭瀵硅瘽妗嗛夋嫨IF鍑芥暟锛岀偣鍑荤‘瀹氥2銆佹柟娉/姝ラ鍦ㄤ笅闈㈢殑瀛︾敓鎴愮哗璇勫畾琛ㄤ腑锛屾垜浠皢瀛︾敓鎴愮哗鎸夌収鍒嗘暟鍒嗕负鍥涗釜绛夌骇锛650-750鍒嗕负鈥滀紭鈥濓紱500-65...
绛旓細1銆佽〃鏍间腑鐨勯粍棰滆壊鍖哄煙涓鸿瘎鍒嗘爣鍑嗭紝瑕佹眰鏍规嵁杩欎釜璇勫垎鏍囧噯瀵笰鍒楃殑瀛︾敓鎴愮哗杩涜璇勭骇鍒掑垎锛岀粨鏋滃湪B鍒楁樉绀恒2銆侀変腑B2鍗曞厓鏍硷紝鍦ㄥ崟鍏冩牸涓緭鍏=]锛岀劧鍚庣偣鍑汇愭彃鍏鍑芥暟銆戞寜閽3銆佸涓嬪浘寮瑰嚭銆愭彃鍏ュ嚱鏁般戝璇濇鍦ㄣ愭垨閫夋嫨绫诲埆銆戜腑閫夋嫨[鍏ㄩ儴]閫夐」锛涘湪銆愰夋嫨鍑芥暟銆戜腑閫夋嫨[LOOKUP]鍑芥暟锛岀劧鍚庣偣鍑汇愮‘瀹氥戞寜閽
绛旓細閫夋嫨鍗曞厓鏍糃3锛屽崟鍑诲叕寮忕紪杈戞爮鏃佽竟鐨勨渇x鈥濇彃鍏ュ嚱鏁版寜閽傚皢浼氬脊鍑烘彃鍏ュ嚱鏁板璇濇銆傚湪Excel涓浣曞埄鐢↖F鍑芥暟瀵瑰鐢熸垚缁╄繘琛岃瘎瀹 鍦ㄥ脊鍑虹殑鈥滄彃鍏ュ嚱鏁扳濆璇濇涓紝鍦ㄢ滄悳绱㈠嚱鏁扳濅腑杈撳叆鈥漣f鈥滐紝骞跺崟鍑烩濊浆鍒扳滄寜閽紝鍦ㄢ濋夋嫨鍑芥暟鈥滃璇濇涓変腑鈥漣f鈥滐紝鍗曞嚮鈥濈‘瀹氣滄寜閽傚湪Excel涓浣曞埄鐢↖F鍑芥暟瀵瑰鐢熸垚缁...
绛旓細1銆佺數鑴戞墦寮Excel琛ㄦ牸銆2銆佹墦寮Excel琛ㄦ牸鍚庯紝杈撳叆鍏紡=IF(D7>=90,"浼",IF(D7>=80,"鑹",IF(D7>=60,"涓","宸")))銆3銆佽緭鍏ュ叕寮=IF(D7>=90,"浼",IF(D7>=80,"鑹",IF(D7>=60,"涓","宸")))鍚庯紝鎸夊洖杞﹂敭鍗冲彲璇勫畾绛夌骇銆4銆佹渶鍚庝笅鎷夊鍒跺叕寮忓嵆鍙
绛旓細Excel 鍑芥暟璇勪环鍙互鎸夌収浠ヤ笅姝ラ杩涜锛1. 纭鎵闇鍑芥暟锛氬湪浣跨敤 Excel 鍑芥暟涔嬪墠锛岄渶瑕佸厛纭畾鎵闇鐨勫嚱鏁扮被鍨嬪拰鍔熻兘銆備緥濡傦紝濡傛灉闇瑕佽绠楀钩鍧囧笺佹诲拰鎴栨渶澶у肩瓑缁熻鏁版嵁锛屽彲浠ヤ娇鐢 SUM銆丄VERAGE 鍜 MAX 绛夊嚱鏁帮紱濡傛灉闇瑕佽繘琛屾枃鏈鐞嗘垨閫昏緫鍒ゆ柇绛夋搷浣滐紝鍙互浣跨敤 CONCATENATE銆両F 鍜 AND 绛夊嚱鏁般2. 鏌ョ湅...
绛旓細瑕瀹炵幇鏈緥鐨勫姛鑳斤紝杩樺彲浠浣跨敤TRIMMEAN鍑芥暟鏉ヨ繘琛岃绠椼傚湪Excel涓紝TRIMMEAN鍑芥暟鍙互鍦ㄥ幓鎺夋暟鎹泦涓竴瀹氱櫨鍒嗘瘮鐨勬渶澶у煎拰鏈灏忓煎悗姹傚墿浣欐暟鎹殑骞冲潎鏁般傝鍑芥暟鐨勮娉曟牸寮忓涓嬶細TRIMMEAN(array,percent)鍏朵腑锛屽弬鏁癮rray涓洪渶瑕佽繘琛屾暣鍒楁眰骞冲潎鍊肩殑鏁扮粍鎴栨暟鍊煎尯鍩;鍙傛暟percent涓鸿绠楁椂瑕侀櫎鍘荤殑鏁版嵁鐐圭殑姣斾緥;鍙傛暟...
绛旓細渚濇嵁涓瀹氱殑鏍囧噯锛屽皢鐩稿簲鐨勫笺佹垚缁╃瓑鍒掑垎鍦ㄥ浐瀹氱殑鑼冨洿涓紝涔熸槸Excel涓粡甯歌鐢ㄥ埌鐨勬搷浣滐紝闄や簡鐢ㄧ洰娴嬩箣澶栵紝杩樻湁6绉嶆柟娉曞彲浠瀹炵幇銆備竴銆丒xcel绛夌骇鍒ゅ畾锛欼F鍑芥暟娉曘傜洰鐨勶細鏍规嵁鈥滄垚缁┾濆垽瀹氣滅瓑绾р濄鏂规硶锛氬湪鐩爣鍗曞厓鏍间腑杈撳叆鍏紡锛=IF(D3=100,"婊″垎",IF(D3>=95,"浼樼",IF(D3>=85,"鑹ソ...
绛旓細1銆佺數鑴戞墦寮Excel琛ㄦ牸锛岃緭鍏ヨ绠楁帓鍚嶇殑鍏紡=RANK(B2,$B$2:$B$9)銆2銆佹寜鍥炶溅纭叕寮忓嵆鍙緱鍒版帓鍚嶃3銆佷笅鎷夊鍒跺叕寮忥紝鍗冲彲绠楀嚭鎵鏈変汉鐨勬帓鍚嶃4銆佽緭鍏ュ叕寮=IF(COUNTIF(B2,">=80"),"浼樼",IF(COUNTIF(B2,"<60"),"宸","鍙婃牸"))銆5銆佸洖杞︾‘璁わ紝涓嬫媺澶嶅埗锛屽鏋滃ぇ浜80鍒嗭紝灏辨樉绀轰紭绉锛屽ぇ浜60...
绛旓細excel涓鎬庝箞鐢ㄥ嚱鏁鍒ゆ柇"浼樼""鑹ソ""宸"浣跨敤IF鍑芥暟灏卞彲浠ヨ繘琛屽垽鏂傝蒋浠跺伐鍏凤細EXCEL 2013 1銆佹瘮濡傚垎绫荤殑A鍒楋紝B鍒椾腑鏄剧ず缁撴灉銆傛潯浠讹細澶т簬绛変簬90鍒嗕负浼樼锛90-60涓鸿壇濂斤紝60浠ヤ笅涓哄樊銆2銆佸湪B1涓緭鍏=IF(A1>=90,"浼樼",IF(A1>=60,"鑹ソ","宸"))鎸変笅鍥炶溅閿3銆佸叾浠栫殑鍗曞厓涓嶇敤杈撳叆锛屼娇鐢ㄥ～鍏...
