Function Get Letter Grade: MS Excel

Function Get Letter Grade from percent score

Public Function GetGradeLetter(Score As Double)
Select Case Score
Case Is < 0.6
GetGradeLetter = “F”
Case Is < 0.7
GetGradeLetter = “D”
Case Is < 0.8
GetGradeLetter = “C”
Case Is < 0.9
GetGradeLetter = “B”
Case Else
GetGradeLetter = “A”
End Select
End Function

 

 

Related posts