Excel 2007 : Two different formulas in one cell

Hey Forum,

I have recently been asked to combine two cells together for some reason that is beyond me.

The formulas in the two cells are as follows.

To work out the final mark (total) of the module by adding the Coursework (weighted at 50%) and Exam (weighted at 50%) together.
=(H9*0.5)+(K9*0.5)


To work out whether a student deserves an RE (Resit Exam), RC (resit Coursework), RM (resit Module), EX (exemption) or NS (Non-submittal)
=IF(AND(H7=0,K7=0),"",IF(AND(H7<39.49,K7<39.49),"RM",IF(H7<39.49,"RC",IF(K7<39.49,"RE",IF(H7="NS","NS",IF(K7="NS","NS",IF(H7="EX","EX",IF(K7="EX","EX", "" ))))))))



So what I need is for in one cell, either a code to come up tell us what the student failed or whether they are exempt, or if applicable to show the total of the two cells.

I would prefer if both pieces of information WEREN'T shown in the same cell but will settle with it if I need too

All the best,

Adam