甯哥敤鐢靛瓙琛ㄦ牸鍏紡
1
銆佹煡鎵鹃噸澶嶅唴瀹瑰叕寮忥細
=IF(COUNTIF(A:A,A2)>1,"
閲嶅
","")
銆?/p>
2
銆佺敤鍑虹敓骞存湀鏉ヨ绠楀勾榫勫叕寮忥細
=TRUNC((DAYS360(H6,"2009/8/30",FALSE))/360,0)
銆?/p>
3
銆佷粠杈撳叆鐨?/p>
18
浣?/p>
韬唤璇佸彿
鐨勫嚭鐢熷勾鏈堣绠楀叕寮忥細
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2))
銆?/p>
4
銆佷粠杈撳叆鐨?/p>
韬唤璇佸彿鐮?/p>
鍐呰绯荤粺鑷姩鎻愬彇鎬у埆锛屽彲浠ヨ緭鍏ヤ互涓嬪叕寮忥細
=IF(LEN(C2)=15,IF(MOD(MID(C2,15,1),2)=1,"
鐢?/p>
","
濂?
"),IF(MOD(MID(C2,17,1),2)=1,"
鐢?/p>
","
濂?/p>
"))
鍏紡鍐呯殑鈥淐2鈥濅唬琛ㄧ殑鏄緭鍏ヨ韩浠借瘉鍙风爜鐨勫崟
鍏冩牸銆?/p>
1
銆佹眰鍜岋細
=SUM(K2:K56)
鈥斺�斿
K2
鍒?/p>
K56
杩欎竴鍖哄煙杩涜姹傚拰锛?/p>
2
銆?/p>
骞冲潎鏁?/p>
锛?/p>
=AVERAGE(K2:K56)
鈥斺�斿
K2 K56
杩欎竴鍖哄煙姹傚钩鍧囨暟锛?/p>
3
銆佹帓鍚嶏細
=RANK(K2
锛?/p>
K$2:K$56)
鈥斺�斿
55
鍚嶅鐢熺殑鎴愮哗杩涜鎺掑悕锛?/p>
4
銆佺瓑绾э細
=IF(K2>=85,"
浼?/p>
",IF(K2>=74,"
鑹?/p>
",IF(K2>=60,"
鍙婃牸
","
涓嶅強鏍?/p>
")))
5
銆佸鏈熸�昏瘎锛?/p>
=K2*0.3+M2*0.3+N2*0.4
鈥斺�斿亣璁?/p>
K
鍒椼�?/p>
M
鍒楀拰
N
鍒楀垎鍒瓨鏀剧潃