bit4bit

Hi, I have an excel project due in tomorrow morning, and one thing I have left to do is to:

"use the lookup function to to convert the average mark per student into degree classifications"

Basically I have a spread sheet describing students final marks for 11 different modules they took over the year. I have created another column to the right, which I have used the '=AVERAGE()' function on for each students average mark. I have then sorted them descending from highest to lowest mark.

What I need to do now is to use this 'lookup' function to assign a degree class to each student based on his/her average mark. All I am told is...

Average mark : Class
>=70 : first class
>=60,<70 : upper second
>=50,<60 : lower second
>=40,<50 : third
>=35,<40 : pass
<35 : fail

-----------key------------
< less than
>= greater than or equal to.
---------------------------

...you can see each average mark will fall within one of the above ranges, and be assigned to the respective class, but I am not told how to use this function in any way.
Basically I'm guessing I will just have to enter it in the first cell and copy down the column. But I cant actually figure out how to use the function itself.


Please if you have any idea of how to do this, help me out.

Thanks!
bit4bit