using an if statement to compare 2 columns of data and return text information

[VanessaF]

Hi

This may seem like a really simple but I am having a problem achieving the required result.

I have 2 columns of data reflecting English and Maths Grades. If the grade for either English or Maths is a C- or below then they haven't achieved the required result in these two subjects so the the third column will indicate which subject they did not achieve in (English, Maths or Both). If the student achieved a C or above in both English and Maths my formula should return a blank cell.

Please have a look at the attached spreadsheet as it will make more sense - I require a formula in the the third column please.

I look forward to hearing from you

kind regards
Vanessa

[GIS2013]

Hi, try this. I've changed a bit your grade system.

[DBY]

Hello Vanessa
As an alternative to GIS2013's solution, If you wish to retain your +/- grades system then maybe you could use a lookup table of Pass Grades as in the attached reply.

Hope this helps.
DBY

[GIS2013]

Improved version. Please ignore my previous one.

[Mazzaropi]

VanessaF, Good Morning.

I did an example for you.
Itīs a simple use of IF and COUNTIF functions.

I hope it helps you.

Have a nice day.

[VanessaF]

Good Morning All - thank you that worked brilliantly. I wasn't even aware that you could name a range and pop it into a formula. AWESOME

Thanks