E
x
c
e
l
甯?/p>
鐢?/p>
鍑?/p>
鏁?/p>
鍏?/p>
寮?/p>
澶?/p>
鍏?
1
銆佹煡鎵鹃噸澶嶅唴瀹瑰叕寮忥細
=IF(COUNTIF(A:A,A2)>1,"
閲嶅
","")
銆?/p>
2
銆佺敤鍑虹敓骞存湀鏉ヨ绠楀勾榫勫叕寮忥細
=TRUNC((DAYS360(H6,"2009/8/30",FALSE))/360,0)
銆?/p>
3
銆佷粠杈撳叆鐨?/p>
18
浣嶈韩浠借瘉鍙风殑鍑虹敓骞存湀璁＄畻鍏紡锛?
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2))
銆?/p>
4
銆佷粠杈撳叆鐨勮韩浠借瘉鍙风爜鍐呰绯荤粺鑷姩鎻愬彇鎬у埆锛屽彲浠ヨ緭鍏ヤ互涓嬪叕寮忥細
=IF(LEN(C2)=15,IF(MOD(MID(C2,15,1),2)=1,"
鐢?/p>
","
濂?/p>
"),IF(MOD(MID(C2,17,1),2)=1,"
鐢?/p>
","
濂?/p>
"))
鍏紡鍐呯殑鈥?/p>
C2
鈥濅唬琛ㄧ殑鏄緭鍏ヨ韩浠借瘉鍙风爜鐨勫崟鍏冩牸銆?/p>
1
銆佹眰鍜岋細
=SUM(K2:K56)
鈥斺�斿
K2
鍒?/p>
K56
杩欎竴鍖哄煙杩涜姹傚拰锛?/p>
2
銆佸钩鍧囨暟锛?/p>
=AVERAGE(K2:K56)
鈥斺�斿
K2K56
杩欎竴鍖哄煙姹傚钩鍧囨暟锛?/p>
3
銆佹帓鍚嶏細
=RANK(K2
锛?/p>
K$2:K$56)
鈥斺�斿
55
鍚嶅鐢熺殑鎴愮哗杩涜鎺掑悕锛?/p>
4
銆佺瓑绾э細
=IF(K2>=85,"
浼?/p>
",IF(K2>=74,"
鑹?/p>
",IF(K2>=60,"
鍙婃牸
","
涓嶅強鏍?/p>
")))