How to upgrade the only one or two grades to their higher level as per condition mentioned in the col. "C" in the below table; i.e
IF A2 THEN A1,
IF B1 THEN A2,
IF B2 THEN B1,
IF C1 THEN B2,
IF C2 THEN C1,
IF D THEN C2,
IF E1 THEN D,
IF E2 THEN E1.
<tbody>
</tbody>
IF A2 THEN A1,
IF B1 THEN A2,
IF B2 THEN B1,
IF C1 THEN B2,
IF C2 THEN C1,
IF D THEN C2,
IF E1 THEN D,
IF E2 THEN E1.
A | B | C | D | E | F | G | H | I | J | K | L | M |
R.N. | NAME | UPGRADATION | ENG. | Upgrade | MATHS | Upgrade | SCI. | Upgrade | S.SCI. | Upgrade | COMP. | Upgrade |
1 | SAM | Upgradation in two subjects | A2 | CI | D | CI | B2 | |||||
2 | JOHN | Upgradation in one subject | BI | BI | CI | CI | A2 | |||||
3 | TOM | Upgradation in two subjects | A1 | A1 | C2 | C1 | B1 | |||||
4 | JIM | No Upgradation | A1 | A2 | BI | BI | B1 |
<tbody>
</tbody>