If this is your truth table.....


Paper1 Paper2 Result
<50 <50 Fail
<50 50 to <80 Fail
<50 =80 Fail
50 to <80 <50 Fail
50 to <80 50 to <80 Pass
50 to <80 =80 Pass
=80 <50 Fail
=80 50 to <80 Pass
=80 =80 Distinction

Then with a Paer 1 score in A1 and Paper2 score in B1, then the
following will work.

=IF(AND(A1=80,B1=80),"Distinction",IF(AND(A1=50 ,B1=50),"Pass","Fail"))

HTH


On 21 Sep 2006 13:48:59 -0700, wrote:

Can you help please?

I have a table where each student has sat 2 papers. If they get 50 or
over it is a pass, if they get 80 or more they distinction and if they
get less then 50, it is a fail. This works fine if they pass or fail
both papers, however if they fail one but get a distinction in the
other, my formula is not working.

thank you

Roni

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________