20150819-成績單2

月份
I2=VLOOKUP(H2,$A$1:$C$12,2,FALSE)

月英文名
J2=VLOOKUP(H2,$A$1:$C$12,3,FALSE)

評等-查表
Y2=HLOOKUP(Q2,查表!$A$15:$E$16,2,TRUE)

評等1-IF
Z2=IF(Q2<60,"E",IF(Q2<70,"D",IF(Q2<80,"C",IF(Q2<90,"B","A"))))

評等2-IF
=IF(Q2>=60,IF(Q2>=70,IF(Q2>=80,IF(Q2>=90,"A","B"),"C"),"D"),"E")

follow以下邏輯
=IF(Q2>=60,"","E")

=IF(Q2>=70,"","D")

=IF(Q2>=80,"","C")

=IF(Q2>=90,"A","B")