0605_學習成績單

V2=IF(R2<=5,IF(COUNTIF(F2:O2,"<60")<1,IF(G2>=97,"直升台大","保送建中"),"再加油!"),"")

01_Excel_學生成績單_060405，Download