Grades in excel

Solved
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,
How do i do the grades in Excel for example if a learner gets 70% how do i classify that using the symbols to grade the result


System Configuration: Android / Chrome 88.0.4324.93

2 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi D.Phiri,

As in:
100% = S
90% = A
80% = B
?

Best regards,
Trowa
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi D.Phiri,

I found a grading scale here:
https://www.wadsworth.k12.oh.us/1/Content2/58

And created a custom function accordingly:
Function GetGrade(Percentage As Range) As String
If Percentage.Value >= 0.93 And Percentage.Value <= 1 Then
    GetGrade = "A"
ElseIf Percentage.Value >= 0.9 And Percentage.Value <= 0.92 Then
    GetGrade = "A-"
ElseIf Percentage.Value >= 0.87 And Percentage.Value <= 0.89 Then
    GetGrade = "B+"
ElseIf Percentage.Value >= 0.83 And Percentage.Value <= 0.86 Then
    GetGrade = "B"
ElseIf Percentage.Value >= 0.8 And Percentage.Value <= 0.82 Then
    GetGrade = "B-"
ElseIf Percentage.Value >= 0.77 And Percentage.Value <= 0.79 Then
    GetGrade = "C+"
ElseIf Percentage.Value >= 0.73 And Percentage.Value <= 0.76 Then
    GetGrade = "C"
ElseIf Percentage.Value >= 0.7 And Percentage.Value <= 0.72 Then
    GetGrade = "C-"
ElseIf Percentage.Value >= 0.67 And Percentage.Value <= 0.69 Then
    GetGrade = "D+"
ElseIf Percentage.Value >= 0.63 And Percentage.Value <= 0.66 Then
    GetGrade = "D"
ElseIf Percentage.Value >= 0.6 And Percentage.Value <= 0.62 Then
    GetGrade = "D-"
ElseIf Percentage.Value <= 0.59 Then
    GetGrade = "F"
End If
End Function


Once you put this code in a standard module and your grading percentages are in column A (for example), you can use it like this:
=GetGrade(A2)

Let us know if alterations are desired.

Best regards,
Trowa