Or you could write your own function.


Function Getletter(str)
If str 90 And str < 101 then
Getletter = "A"
ElseIf str 80 And str < 91 then
Getletter = "B"
ElseIf str 70 And str < 81 then
Getletter = "C"
ElseIf str 60 And str < 71
Getletter = "D"
Else
Getletter = "F"
End If


' Select Case str
' Case str 90 And str < 101
' Getletter = "A"
' Case str 80 And str < 91
' Getletter = "B"
' Case str 70 And str < 81
' Getletter = "C"
' Case str 60 And str < 71
' Getletter = "D"
' End Select
End Function

"chayrun" wrote:

I have to convert my number scores to letter scores.

example of ranges: 300 to 400 = A. Is there anyway I can enter all my
ranges for letter grades a, b, c, d, f and the program will return a letter
grade.

I looked in convert and if statements, but couldn't really find it.

Thank you Cindy