Hi everybody.

This is my first post and i'm already asking for help! Well anyway i'm
quite new to excel so I shall be visiting these areas quite alot in
order to help me get a grasp of it. If I posted this in the wrong
section I do apologise, as i'm not sure what category it's classed as.

My problem is that I have an average mark of a students results over
the past year (which is located in cell 48), with this mark I would
like to be able to convert his mark into a grade in a different cell. I
would like this to be repeatable for a list of students with different
average marks.

Below is what i've done so far but I just don't know what to do as the
problem I get is all my grades no matter what the marks coming up with
an 'F'.

=IF(E48=70,"FIRST", IF(E48=60,"TWO:ONE", IF(E48=50,"TWO:TWO",
IF(E48=40,"THIRD","F")))

Obviously the 'FIRST' and 'TWO:TWO' is the grade the student will get.
As said above, cell E48 is this students average mark.

I hope you guys can help me, and great work! Keep up the advice, i'll
need it!


--
Travis
------------------------------------------------------------------------
Travis's Profile: http://www.excelforum.com/member.php...o&userid=32502
View this thread: http://www.excelforum.com/showthread...hreadid=522921