[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]
<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]
removed bad image attempt<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:
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:
Last edited by a moderator: