I'm new to microsoft Excel. I have to record a set of test results (x5) and work out each students overall grade. For example...

Student 1 achieves the following set of results...

Test 1 - 80
Test 2 - 30
Test 3 - 64
Test 4 - 56
Test 5 - 23

His overall score is therefore '253'.

But I need to know his OVERALL grade. The grading classifactions are as follows:

0F
39D
49C
59B
69A
100

Does this mean anything to anybody? Or are you just as confused as I am? Thank You.
I'm quite sure that I need to use the Horizontal Lookup function, but I've only been able to work out a student's grade for each of the tests using the formula:

=LOOKUP(C4,{0,39,49,59,69,100},{"F","D","C","B","A "}
P.S. I think I have to use the lookup function, but I also think that it'd be possible to create another column (average) and then work out the grade from that using the formula that I just described above.

It seems that you would want to use the AVERAGE grade in the LOOKUP statement.

So, for example, if the 5 test scores are in B2:F2, you would have

=LOOKUP(AVERAGE(B2:F2), {0,39,49,59,69,100}, {"F","D","C","B","A","A+"})

In your example, the average is 50.6 (253/5), so the overall grade would be "C".

If you need more info, add more details or e-mail.
Good luck.
.