Total point grading system review!

[LONGO]

Hello!
Im confusing how to join two formula in excel at once as what Mr AlanY did like this so PLEASE! I need an help.
Basically Im grading the student who is taking combination of three subjects, with TWO criteria

1. By considering weight of points as in table below shows;
2. By DIVISION without considering the aggregated point should have at least two subsidiaries (S) or at least One Principal Pass (E), otherwise if has less than two S will get O<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]-->

As what table show below:[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]PNT[/TD]
[TD]DIV[/TD]
[TD]SU[/TD]
[TD]BJE[/TD]
[TD]CT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]P[/TD]
[TD]C[/TD]
[TD]M[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]POINT[/TD]
[TD]DIVISION[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]90
[/TD]
[TD="align: center"]80
[/TD]
[TD="align: center"]90
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: center"]13
[/TD]
[TD="align: center"]III
[/TD]
[TD="align: center"]17
[/TD]
[TD="align: center"]88
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]5
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]12
[/TD]
[TD="align: center"]II
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]55
[/TD]
[TD="align: center"]67
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]87
[/TD]
[TD="align: center"]76
[/TD]
[TD="align: center"]77
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]-
[/TD]
[TD="align: center"]ABS
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]III
[/TD]
[TD="align: center"]54
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]23
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: center"]-
[/TD]
[TD="align: center"]IV
[/TD]
[TD="align: center"]45
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: center"]-
[/TD]
[TD="align: center"]IV
[/TD]
[TD="align: center"]30
[/TD]
[TD="align: center"]30
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: center"]-
[/TD]
[TD="align: center"]IV
[/TD]
[TD="align: center"]23
[/TD]
[TD="align: center"]30
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: center"]-
[/TD]
[TD="align: center"]IV
[/TD]
[TD="align: center"]70
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Column A&B is what is needed to appear at column I & J
The guide is:
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]GRADE[/TD]
[TD]SCORE RANGE[/TD]
[TD]GRADE POINT[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]80-100[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]70-79[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]60-69[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]50-59[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]40-49[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD]35-39[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]0-34[/TD]
[TD]7[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in Advance,
Im ready to hear more from you!

 

[LONGO]

If Selection.Offset(0, 8).Value = "S" And Selection.Offset(0, 9).Value = "S" Then
    If Selection.Offset(0, 10).Value = "X" Or Selection.Offset(0, 10).Value = "F" Then
     Selection.Offset(0, 7).Value = "IV"
    End If
   ElseIf Selection.Offset(0, 8).Value = "E" And Selection.Offset(0, 9).Value = "X" And Selection.Offset(0, 10).Value = "X" Then
    Selection.Offset(0, 7).Value = "IV"
   ElseIf Selection.Offset(0, 8).Value = "E" And Selection.Offset(0, 9).Value = "F" Then
    If Selection.Offset(0, 10).Value = "X" Or Selection.Offset(0, 10).Value = "F" Then
     Selection.Offset(0, 7).Value = "IV"
    End If
   ElseIf Selection.Offset(0, 8).Value = "S" And Selection.Offset(0, 9).Value = "X" And Selection.Offset(0, 10).Value = "X" Then
    Selection.Offset(0, 7).Value = "IV"
   ElseIf Selection.Offset(0, 8).Value = "S" And Selection.Offset(0, 9).Value = "F" Then
    If Selection.Offset(0, 10).Value = "X" Or Selection.Offset(0, 10).Value = "F" Then
     Selection.Offset(0, 7).Value = "O"
    End If
   ElseIf Selection.Offset(0, 9).Value = "X" And Selection.Offset(0, 10).Value = "X" Then
    If Selection.Offset(0, 8).Value = "F" Or Selection.Offset(0, 8).Value = "B" Then
     Selection.Offset(0, 7).Value = "IV"
    End If
End If

Include the code in RED.

Thanks for your kindness!

 

[pmich]

Welcome.