=LOOKUP(A1,{0,50,60,70,80,90;"F","E","D","C","B"," A"})
Adjust accordingly assuming the scoiresa are on cell A1


"JDenio" wrote in message
...
i need a formula to place in my spreadsheet that provides the following:
If a number is or < a value, then place an alpha character in the cell.
I am a teacher and am trying to have the excel spreadsheet put the letter
grade in the cell where the total number of points earned is (because we
don't use the number of points, but letter grades).