Grades in excel
Solved/Closed
D.Phiri
-
May 1, 2021 at 03:45 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 4, 2021 at 11:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 4, 2021 at 11:56 AM
Related:
- Grades in excel
- Excel grade formula - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- How to take screenshot in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 3, 2021 at 12:16 PM
May 3, 2021 at 12:16 PM
Hi D.Phiri,
As in:
100% = S
90% = A
80% = B
?
Best regards,
Trowa
As in:
100% = S
90% = A
80% = B
?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 4, 2021 at 11:56 AM
May 4, 2021 at 11:56 AM
Hi D.Phiri,
I found a grading scale here:
https://www.wadsworth.k12.oh.us/1/Content2/58
And created a custom function accordingly:
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
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
