Students' grade scores calculation in division base.

[LONGO]

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Cand. No[/TD]
[TD="align: center"]Lit[/TD]
[TD]Civ[/TD]
[TD]His[/TD]
[TD]Kisw[/TD]
[TD]Bios[/TD]
[TD]Math[/TD]
[TD]Engl[/TD]
[TD]Phy[/TD]
[TD]Chem[/TD]
[TD]DIV[/TD]
[TD="align: right"]PONTS[/TD]
[/TR]
[TR]
[TD]0001[/TD]
[TD]37[/TD]
[TD]45[/TD]
[TD]67[/TD]
[TD]89[/TD]
[TD]90[/TD]
[TD]23[/TD]
[TD]23[/TD]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0002[/TD]
[TD]24[/TD]
[TD]56[/TD]
[TD]78[/TD]
[TD]90[/TD]
[TD]34[/TD]
[TD]12[/TD]
[TD]17[/TD]
[TD]88[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0003[/TD]
[TD]56[/TD]
[TD]78[/TD]
[TD]90[/TD]
[TD]78[/TD]
[TD]X[/TD]
[TD]33[/TD]
[TD]45[/TD]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0004[/TD]
[TD]23[/TD]
[TD]34[/TD]
[TD]45[/TD]
[TD]58[/TD]
[TD]78[/TD]
[TD]89[/TD]
[TD]87[/TD]
[TD]76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0005[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]ABS[/TD]
[TD]--[/TD]
[/TR]
[TR]
[TD]0006[/TD]
[TD]56[/TD]
[TD]78[/TD]
[TD]90[/TD]
[TD]87[/TD]
[TD]65[/TD]
[TD]76[/TD]
[TD]54[/TD]
[TD]45[/TD]
[TD]23[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0007[/TD]
[TD]56[/TD]
[TD]78[/TD]
[TD]54[/TD]
[TD]45[/TD]
[TD]39[/TD]
[TD]00[/TD]
[TD]45[/TD]
[TD]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0008[/TD]
[TD]89[/TD]
[TD]78[/TD]
[TD]90[/TD]
[TD]77[/TD]
[TD]67[/TD]
[TD]89[/TD]
[TD]90[/TD]
[TD]93[/TD]
[TD]79[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 100, align: center"]
<tbody>[TR]
[TD]MARKS[/TD]
[TD]GRADE[/TD]
[TD]POINTS[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]F[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]D[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]C[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 100, align: center"]
<tbody>[TR]
[TD]POINTS[/TD]
[TD]DIVISION[/TD]
[/TR]
[TR]
[TD]7-17[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]18-21[/TD]
[TD]II[/TD]
[/TR]
[TR]
[TD]22-25[/TD]
[TD]III[/TD]
[/TR]
[TR]
[TD]26-33[/TD]
[TD]IV[/TD]
[/TR]
[TR]
[TD]34-35[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

Hello Members!
Im looking for the formula of calculating division and points for exam results for my students which will penalize the pass candidate who got grade "F" for Math and return DIV III instead of being pass in DIV I or II. Since Math is compulsory.
Thanks in Advance!



For me i did like this but i failed the condition in red:
​

removed bad image attempt

 

[AlanY]

your attached image didn't show up, try this

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K	L
1	Cand. No	Lit	Civ	His	Kisw	Bios	Math	Engl	Phy	Chem	DIV	PONTS
2	1	37	45	67	89	90	23	23	34		III	25
3	2	24	56	78	90	34	12	17	88	45	III	25
4	3	56	78	90	78	X	33	45	55		I	16
5	4	23	34	45	58	78	89	87	76		II	19
6	5	X	X	X	X	X	X	X	X		X	0
7	6	56	78	90	87	65	76	54	45	23	I	15
8	7	56	78	54	45	39	0	45	56		III	10
9	8	89	78	90	77	67	10	90	93	79	III	13
10	9	89	78	90	77	67	89	90	93	79	I	9
Sheet1

Cell Formulas
Range	Formula
K2	{=IFNA(LOOKUP(IF(G2<30,MAX(L2,25)-0.1,L2-0.1),{0;17;21;25;33},{"I","II","III","IV",0}),"X")}
L2	{=SUM(IFNA(LOOKUP(B2:I2,{0;30;45;65;75},{5;4;3;2;1}),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[oldbrewer]

[TABLE="width: 1240"]
<colgroup><col><col span="14"></colgroup><tbody>[TR]
[TD]Cand. No[/TD]
[TD]Lit[/TD]
[TD]Civ[/TD]
[TD]His[/TD]
[TD]Kisw[/TD]
[TD]Bios[/TD]
[TD]Math[/TD]
[TD]Engl[/TD]
[TD]Phy[/TD]
[TD]Chem[/TD]
[TD]DIV[/TD]
[TD]PONTS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]78[/TD]
[TD]X[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]76[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]X[/TD]
[TD]ABS[/TD]
[TD]--[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MARKS[/TD]
[TD]GRADE[/TD]
[TD]POINTS[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD]F[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD]D[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]45[/TD]
[TD]C[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]75[/TD]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]POINTS[/TD]
[TD]DIVISION[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD]I[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD]II[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25[/TD]
[TD]III[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]33[/TD]
[TD]IV[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]35[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Im looking for formula of calculating division & points for exam results for my students which will penalize the pass candidate with "F" for Math and return DIV III instead of being pass in DIV I or II. Since Math is compulsory.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cand. No[/TD]
[TD]Lit[/TD]
[TD]Civ[/TD]
[TD]His[/TD]
[TD]Kisw[/TD]
[TD]Bios[/TD]
[TD]Math[/TD]
[TD]Engl[/TD]
[TD]Phy[/TD]
[TD]Chem[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]B[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]F[/TD]
[TD]F[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]F[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]F[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]n/a[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]F[/TD]
[TD]D[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]C[/TD]
[TD]A[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]C[/TD]
[TD]C[/TD]
[TD]F[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cand. No[/TD]
[TD]Lit[/TD]
[TD]Civ[/TD]
[TD]His[/TD]
[TD]Kisw[/TD]
[TD]Bios[/TD]
[TD]Math[/TD]
[TD]Engl[/TD]
[TD]Phy[/TD]
[TD]Chem[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD]III[/TD]
[TD]III[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]28[/TD]
[TD]III[/TD]
[TD]III[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD]n/a[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]21[/TD]
[TD]II[/TD]
[TD]II[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD]II[/TD]
[TD]II[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD]n/a[/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[TD]III[/TD]
[TD]III[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[TD]I[/TD]
[TD]I[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]is this what you want[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]easy to get grade and points[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[LONGO]

your attached image didn't show up, try this

Excel 2013/2016

	A	B	C	D	E	F	G	H	I	J	K	L
Cand. No	Lit	Civ	His	Kisw	Bios	Math	Engl	Phy	Chem
X
X	X	X	X	X	X	X	X

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]DIV[/TD]
[TD="align: center"]PONTS[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]III[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]25[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]45[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]III[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]25[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]78[/TD]

[TD="align: right"]33[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]I[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]16[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]II[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]19[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]X[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]0[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]23[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]I[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]15[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]III[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]10[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]67[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]10[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]79[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]III[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]13[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"]67[/TD]
[TD="align: right"]89[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]79[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]I[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E2EFDA]#E2EFDA[/URL] , align: center"]9[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula
[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]K2[/TH]
[TD="align: left"]{=IFNA(LOOKUP(IF(G2<30,MAX(L2,25)-0.1,L2-0.1),{0;17;21;25;33},{"I","II","III","IV",0}),"X")}
[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L2[/TH]
[TD="align: left"]{=SUM(IFNA(LOOKUP(B2:I2,{0;30;45;65;75},{5;4;3;2;1}),0))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

Hello! Thanks for your respond it worked for me as what you did, but i have stack to combine in my formula it show too long argument in formula bar. Since i want the formula as what you did but it should select best 7 scores in raw of candidate because the first division it start with (div I point 7 for candidate who got 7 A's).

Thanks in advance!

 

[AlanY]

Hello! Thanks for your respond it worked for me as what you did, but i have stack to combine in my formula it show too long argument in formula bar. Since i want the formula as what you did but it should select best 7 scores in raw of candidate because the first division it start with (div I point 7 for candidate who got 7 A's).

Thanks in advance!

i'm in lost as what's required.
would you explain a bit more?

 

[LONGO]

Your not lost you did right but im sorry i did mistake in my first Qn.

I need the formula which it can satisfy the following condition:

Since i have two groups of students, who have to take 7 subjects or above 7 up to 10 subjects.
But calculation of division it based only on 7 subjects. So now it should look only 7 best scored subjects among all subjects in the raw
Example 67, 65,80, 90, 74, 68 89, 57, 36, 78 so here i have to select 90,89,80,78,74,68,67, including Math and if math scores F
he/she should get div III as what you did before. In addition to the 'X X X X X X X' means absent candidate he/she should
appear as ABS in column of Div with '-' in points column. Please refer to the first asked data above.

Thanks for your kindness!

 

[AlanY]

ok, a bit more complicated that I anticipated thus I use a helper table in Columns L-U that can be hidden.
since you mentioned up to 10 subjects I'd added a dummy subject (Other) to cover it.

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J	K
1	Cand. No	Lit	Civ	His	Kisw	Bios	Math	Engl	Phy	Chem	Other
2	1	37	45	67	89	90	23	23	34
3	2	24	56	78	90	34	12	17	88	45	45
4	3	56	78	90	78	X	33	45	55
5	4	23	34	45	58	78	89	87	76
6	5	X	X	X	X	X	X	X	X	X	X
7	6	56	78	90	87	65	76	54	45	23	23
8	7	56	78	54	45	39	0	45	56
9	8	89	78	90	77	67	10	90	93	79	79
10	9	89	78	90	77	67	89	90	93	79	79
Sheet2

Excel 2013/2016
	L	M	N	O	P	Q	R	S	T	U	V	W
1	Lit	Civ	His	Kisw	Bios	Math	Engl	Phy	Chem	Other	Top7	Grade
2	4	3	2	1	1	5	5	4	5	5	31	IV
3	5	3	1	1	4	5	5	1	3	3	28	IV
4	3	1	1	1	X	4	3	3	5	5	24	III
5	5	4	3	3	1	1	1	1	5	5	26	IV
6	X	X	X	X	X	X	X	X	X	X	ABS	-
7	3	1	1	1	2	1	3	3	5	5	22	III
8	3	1	3	3	4	5	3	3	5	5	28	IV
9	1	1	1	1	2	5	1	1	1	1	12	III
10	1	1	1	1	2	1	1	1	1	1	8	I
Sheet2

Cell Formulas
Range	Formula
L2	=IFNA(LOOKUP(B2,{0;30;45;65;75},{5;4;3;2;1}),"X")
V2	{=IFERROR(SUM(LARGE(L2:U2,ROW(INDIRECT("$1:$"&MIN(7,COUNT(L2:U2)))))),"ABS")}
W2	{=IFERROR(LOOKUP(IF(G2<30,MAX(V2,25)-0.1,V2-0.1),{0;17;21;25;33},{"I","II","III","IV",0}),"-")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[LONGO]

Regard the post the post above i asked how to arrange students scores in division and you response well. Thanks!
The formula it works so good. Now i need some correction on it especially
The one who get at least two S (which = 6) or one principal pass not less than E (=5) should follow in Division IV and 1 S should get DIV 0
Where A,B,C,D and E are Principal pass and S is Subsidiary.
Example: The student require to take three subjects in order to get his/her DIV.
here, A, X, X he or she should get DIV IV: S, X,X get DIV 0, E,X,X gets DIV IV , A,A,A gets DIV 1 point 7 the others point will be "-" I use the formula above but
i failed to return this.

The Guide and Points
80-100 = A
70-79= B
60-69 =C
50-59=D
40-49=E
35-39=S
0-34=F
WHERE A=1,B=2,C=3,D=4,E=5,S=6,F=7.

DIVISION:
3-9=I,
10-12=II,
13-17=III,
18-19=IV,
20-21=0

 

[LONGO]

Regard the post the post above i asked how to arrange students scores in division and you response well. Thanks!
The formula it works so good. Now i need some correction on it especially
The one who get at least two S (which = 6) or one principal pass not less than E (=5) should follow in Division IV and 1 S should get DIV 0
Where A,B,C,D and E are Principal pass and S is Subsidiary.
Example: The student require to take three subjects in order to get his/her DIV.
here, A, X, X he or she should get DIV IV: S, X,X get DIV 0, E,X,X gets DIV IV , A,A,A gets DIV 1 point 7 the others point will be "-" I use the formula above but
i failed to return this.

The Guide and Points
80-100 = A
70-79= B
60-69 =C
50-59=D
40-49=E
35-39=S
0-34=F
WHERE A=1,B=2,C=3,D=4,E=5,S=6,F=7.

DIVISION:
3-9=I,
10-12=II,
13-17=III,
18-19=IV,
20-21=0

https://www.dropbox.com/s/oep55v1dz21ni1p/PROBLEM REQUIED TO BE SOLVED.png?dl=0
[COLOR=inherit !important]


<link rel="stylesheet" type="text/css" href="moz-extension://ae186323-0ade-4617-9576-8a4b1411d75e/skin/s3gt_tooltip_mini.css"><style type="text/css" media="print">#s3gt_translate_tooltip_mini { display: none !important; }</style>[/COLOR]

 

[LONGO]

<colgroup><col style="mso-width-source:userset;mso-width-alt:1422; width:30pt" width="40" span="2"> <col style="mso-width-source:userset;mso-width-alt:1422;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:1422;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:1422;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:1422; width:30pt" width="40" span="3"> <col style="mso-width-source:userset;mso-width-alt:1422;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:1479;width:31pt" width="42"> </colgroup><tbody>
[TD="class: xl88, width: 80, colspan: 2"]REQUIRED
[/TD]
[TD="class: xl88, width: 120, colspan: 3"]SUBJECTS[/TD]
[TD="class: xl95, width: 120, colspan: 3"]WEIGHT
[/TD]
[TD="class: xl93, width: 82, colspan: 2"]TO RETURN[/TD]

[TD="class: xl92"]POINT[/TD]
[TD="class: xl92"]DIV[/TD]
[TD="class: xl89"]H[/TD]
[TD="class: xl89"]K[/TD]
[TD="class: xl89"]L[/TD]
[TD="class: xl69"]POINT
[/TD]
[TD="class: xl69"]DIV[/TD]

[TD="class: xl90"]3[/TD]
[TD="class: xl91"]I[/TD]
[TD="class: xl71"]90[/TD]
[TD="class: xl72"]80[/TD]
[TD="class: xl73"]90[/TD]
[TD="class: xl70"]1[/TD]
[TD="class: xl70"]1[/TD]
[TD="class: xl70"]1
[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl83"] [/TD]

[TD="class: xl79"]13[/TD]
[TD="class: xl84"]III
[/TD]
[TD="class: xl71"]17[/TD]
[TD="class: xl72"]88[/TD]
[TD="class: xl73"]45[/TD]
[TD="class: xl74"]7[/TD]
[TD="class: xl74"]1[/TD]
[TD="class: xl74"]5[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]12[/TD]
[TD="class: xl84"]II[/TD]
[TD="class: xl71"]45[/TD]
[TD="class: xl72"]55[/TD]
[TD="class: xl73"]67[/TD]
[TD="class: xl74"]5[/TD]
[TD="class: xl74"]4[/TD]
[TD="class: xl74"]3[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]5[/TD]
[TD="class: xl84"]I[/TD]
[TD="class: xl71"]87[/TD]
[TD="class: xl72"]76[/TD]
[TD="class: xl73"]77[/TD]
[TD="class: xl74"]1[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl74"]2[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]-[/TD]
[TD="class: xl84"]ABS[/TD]
[TD="class: xl71"]X[/TD]
[TD="class: xl72"]X[/TD]
[TD="class: xl73"]X[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]16[/TD]
[TD="class: xl84"]III[/TD]
[TD="class: xl71"]54[/TD]
[TD="class: xl72"]45[/TD]
[TD="class: xl73"]23[/TD]
[TD="class: xl74"]4[/TD]
[TD="class: xl74"]5[/TD]
[TD="class: xl74"]7[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]-[/TD]
[TD="class: xl84"]IV[/TD]
[TD="class: xl71"]45[/TD]
[TD="class: xl72"]X[/TD]
[TD="class: xl73"]X[/TD]
[TD="class: xl74"]5[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl79"]-[/TD]
[TD="class: xl84"]IV[/TD]
[TD="class: xl71"]30[/TD]
[TD="class: xl72"]30[/TD]
[TD="class: xl73"]X[/TD]
[TD="class: xl74"]7[/TD]
[TD="class: xl74"]7[/TD]
[TD="class: xl74"]X[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl85"] [/TD]

[TD="class: xl80"]-[/TD]
[TD="class: xl86"]IV[/TD]
[TD="class: xl75"]23[/TD]
[TD="class: xl76"]30[/TD]
[TD="class: xl77"]X[/TD]
[TD="class: xl78"]7[/TD]
[TD="class: xl78"]7[/TD]
[TD="class: xl78"]X[/TD]
[TD="class: xl81"] [/TD]
[TD="class: xl87"] [/TD]

</tbody>