kamaruddinjnv
Board Regular
- Joined
- Mar 14, 2014
- Messages
- 56
A | B | C | D | E | F | G | H | I | |||
2 | subjects upgraded | ||||||||||
SUBJECT | OBTAINED GRADE | UPGRADED GRADE | Table of Obtained Marks for Upscaling Purpose. | ||||||||
Overall Marks (100%) | SA1+SA2 (60%) | FA(1-4)- 40% | SA1+SA2 Marks (out of 100) !!! | ||||||||
6 HINDI | A1 | 60.00 | 20.00 | 40.00 | 33.33 | ||||||
7 ENGL | C1 | 80.00 | 50.00 | 30.00 | 83.33 | ||||||
8 MATHS | C2 | 63.00 | 33.00 | 30.00 | 55.00 | ||||||
9 SCIEN | B1 | 63.00 | 33.00 | 30.00 | 55.00 | ||||||
10 S.st | B2 | 85.00 | 55.00 | 30.00 | 91.67 | ||||||
Table for Upgradation | |||||||||||
From | E2 | E1 | D | C2 | C1 | B2 | B1 | A2 | A1 | ||
To | No Upgrade | D | C2 | C1 | B2 | B1 | A2 | A1 | No Upgrade | ||
I want Fix a formula in C6:C10 for upgrade the grade mentioned in B6:B10 acording to table given above. | |||||||||||
Condition : | 1-if B2=0 , No upgrade, if B2=1, upgrade one subject grade, if B2=2, upgrade two subjects. | ||||||||||
2- Upgradation will be from lower grade to upper grade | |||||||||||
3- if there is tie in two subject grade then grade will be upgraded according to heigest marks obtained in Overall marks, if overall marks (column-E) is tie then this condition will be shifted to next column-F, if this also tie then condition will be shifted to next column-G. | |||||||||||
4- if Marks obtained in column -I less than 25% then E1 grade will not be upgrade. | |||||||||||
** for details please see attachment. | http://files.kamaruddin.webnode.com/200000298-2bb8a2cb7f/UPGRADE FORMULA.xlsx |
<tbody>
</tbody>
Last edited: