I am teacher and I have a sheet set up to record student test results. I
type in the score (out of 60) and the sheet calculates a percentage. I have
then entered an IF function in the next column to convert this pergentage
into a grade (a letter grade from A to G). My difficulty is in the next stage
.. . .

Some students are going to sit a higer paper (H) and some a foundation paper
(F). I have a column where H or F is entered in order to record this
information. The papers however have different pass marks (e.g. 55% in a
Higher paper gets a "C" but only gets a "E" in the Foundation paper).

What I want to do (unsucessfully at the moment!) is get Excel to look to see
if there's an H or F in the first column, then perform an IF calculation (or
maybe some other function?) to convert the score into a grade relevant for
that paper.

Any help on this would be really appreciated. I have tried lots of IFs, ANDs
and other functions without success - it's driving me nuts!