changing score from number to letter grade

[Guest]

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

 

[Guest]

This can be done with a vlookup formula. The list that you are looking up
into needs to be sorted and the final argument in the vlookup function must
be set to true...

400 A
300 B
250 C

=Vlookup(A2, Sheet2!A1:B10, 2, true)

Or something like that...

 

[Guest]

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

 

[Guest]

Add a column to the right of your totals and paste this.
=IF(A1>325,"A",IF(A1>250,"B",IF(A1>175,"C",IF(A1>100,"D","F"))))
Change A1 to the column containing your total. Fill down for all totals.
If you don't want the totals to show change the totals column width to zero.

Lou