_N_ | 수업 | 학점 | 등급번호 | 엑셀함수식 |
1 | 가 | A | 1 | =IF(B2=B1,IF(C2=C1,E1,E1+1),1) |
2 | 가 | B | 2 | =IF(B3=B2,IF(C3=C2,E2,E2+1),1) |
3 | 가 | B | 2 | =IF(B4=B3,IF(C4=C3,E3,E3+1),1) |
4 | 가 | C | 3 | =IF(B5=B4,IF(C5=C4,E4,E4+1),1) |
5 | 가 | C | 3 | =IF(B6=B5,IF(C6=C5,E5,E5+1),1) |
6 | 나 | A | 1 | =IF(B7=B6,IF(C7=C6,E6,E6+1),1) |
7 | 나 | B | 2 | =IF(B8=B7,IF(C8=C7,E7,E7+1),1) |
8 | 나 | B | 2 | =IF(B9=B8,IF(C9=C8,E8,E8+1),1) |
9 | 나 | C | 3 | =IF(B10=B9,IF(C10=C9,E9,E9+1),1) |
10 | 나 | C | 3 | =IF(B11=B10,IF(C11=C10,E10,E10+1),1) |