HiDarrell,

I just want to reiterate why I've used those numbers in AO13:AO15 for
the Higher grades and in AP13:AP16 for the Foundation grades. These
numbers represent the top possible score for each grade ie 79 is the
top possible score for a B (H) therefore the formula first checks to
see if the mark is greater than 79 (AO12 = 79), which would result in
an A (H). If this is not the case then the formula checks to see if the
mark is greater than 64 (AO13=64), which would result in a B (H), etc.

I teach Science to adolescents in a Sydney (Australia) State High
School and I use Excel all the time. Your problem is a little more
complicated than usual. I guess you could achieve the same result with
one formula in one column rather than using three columns like I'm
suggesting, but its just after midnight here and my brain's slowing
right down. I'll look into it another time.

Hope you find this useful.

Ken Johnson