Grades in excel
Solved/Closed
D.Phiri
-
1 May 2021 à 03:45
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 May 2021 à 11:56
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 May 2021 à 11:56
Related:
- How to find grade in excel
- Grade formula in excel marksheet - Guide
- Papers grade please - Download - Puzzle
- How to clear formatting in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
3 May 2021 à 12:16
3 May 2021 à 12:16
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
4 May 2021 à 11:56
4 May 2021 à 11:56
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
