Solved/Closed
D.Phiri - May 1, 2021 at 03:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - May 4, 2021 at 11:56 AM
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

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
May 3, 2021 at 12:16 PM
Hi D.Phiri,

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

Best regards,
Trowa
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
May 4, 2021 at 11:56 AM
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