This might help!

let's assume you have test score in A1:A10, you would use =AVERAGE(A1:A10)
in B1 to get an average score, then in another cell you would put:
=LOOKUP(B1,{0,55,60,65,70,75,80,85,90,95,100},{"F" ,"D","C-","C","C+","B-","B","B+","A-","A","A+"})
to get a matching grade.

{0,55,60,65,70,75,80,85,90,95,100}..... these scores will trigger a
different letter grade...... i.e a score of 63 would be C-, a 50 an F and so
on.
and
{"F","D","C-","C","C+","B-","B","B+","A-","A","A+"}...matching letter grades

of course the scores and matching letter grade are just made up so you would
need to ajust them. Just make sure you have the same number of entry in each
brackets.

Hope this help!
JG



"NicoleLT06" wrote:

I'm trying to use Excel, which I know is possible, to set up a grade book
without using a template. I can enter students and points, I just don't know
how to get it to average and give a letter grade. I don't want to download a
template because I know there's a way to do it without one.