Solved
-
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:

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