Grade Problem
 

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

Grade Problem
 

Can't see much wrong with your formula except for a missing parenthesis
at the end.

Often, instead of multiple IFs you can use a lookup type formula,
either self-contained with the formula, e.g.

=LOOKUP(E48,{0,40,50,60,70;"F","THIRD","TWO:TWO"," TWO:ONE","FIRST"})

or if you construct a table A1:B5, i.e. A1 contains 0, A2 40, A3 50
etc, and B1 F, B2 THIRD, B3 TWO:TWO etc. and use formula

=LOOKUP(E48,A1:B5)


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

Grade Problem
 

http://www.cpearson.com/excel/excelF.htm#Grades


"Travis" wrote in
message ...

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