0604_學習成績單

01_Excel_學生成績單_060401，Download

F2=LEFT(E2,FIND("@",E2)-1)
G2=RIGHT(E2,LEN(E2)-FIND("@",E2))
H2=MID(E2,FIND("@",E2)+1,LEN(E2)-FIND("@",E2))

01_Excel_學生成績單_060402，Download

B2=LEFT(A2,2)&"年級，學號"&RIGHT(A2,3)
C2=CONCATENATE(LEFT(A2,2),"年級，學號",RIGHT(A2,3))

S2=IF(R2<=5,"進入甄選","")
T2=COUNTIF(F2:O2,"<60")
U2=IF(R2<=5,IF(COUNTIF(F2:O2,"<60")<1,"保送建中","再加油!"),"")

01_Excel_學生成績單_060403，Download

01_Excel_學生成績單_060404，Download

02_Excel_管理日記帳_060401，Download