So what are the 2 different sets of grades for H and F

here's a way to do it, assume that the first paper is in B3 and the score in
C3

=IF(B3="","",IF(B3="F",VLOOKUP(C3,{0,"G";0.45,"F"; 0.55,"E";0.65,"D";0.75,"C";0.85,"B";0.95,"A"},2),V LOOKUP(C3,{0,"G";0.45,"F";0.55,"C";0.65,"D";0.75," C";0.85,"B";0.95,"A"},2)))

the vlookup tables are identical with the exception of 55%, first is for F
second for H, replace the grades/scores with what you need

--
Regards,

Peo Sjoblom

(No private emails please)


"dazp1970" wrote in message
...
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!