Excel 2007 : Two different formulas in one cell

**master.osgood** · 07-29-2010, 12:50 PM

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

**royUK** · 07-29-2010, 01:31 PM

Can't you set up a Lookup Table?

Maybe attach a dummy workbook

**master.osgood** · 07-29-2010, 01:39 PM

Originally Posted by royUK

Can't you set up a Lookup Table?

Maybe attach a dummy workbook

I haven't tried using a Lookup Table, no.

I have attached a dummy workbook. I literally just need to put the two formulas together. The one in the Total column, and the one in the Grade column.

I'll refresh my memory in lookup table whilst people have a look at this and see if they have any ideas.

Cheers.