Hi Bob,

I have a spreadsheet that has a student name in column B, in column C
is the first test result, in column D the second test result, column E
has the third test result, F has the fourth, G has the fifth, and H has
the sixth. In column I i would like to add a function that will add up
all the scores and if the overall score is under 40 they failed under
60 they pass and so on. I want it to show the words instead of the
score so I am guessing I need a case statement.

Hope this helps. :)

Andy


--
Andy123
------------------------------------------------------------------------
Andy123's Profile: http://www.excelforum.com/member.php...o&userid=29886
View this thread: http://www.excelforum.com/showthread...hreadid=495902