With the test scores in A1 and B1

=IF(AND(MIN(A1,B1)=45,MAX(A1,B1)=60),"Pass","Not Pass")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"cyberbob20k"
wrote in message
...

i need a formula that will work out compensated scores in two exams. the
pass mark in each exam is 50%, but a student who attains 45% in one exam
and a high mark in the other exam such that DOUBLE THE DEFICIT required
to pass the 1st exam can be subtracted from the second score to yeild
both exams as a passed compensated score. for example, a student who
gets a 45 and a 60 will pass but one who gets a 45 and 59 will not. Any
help would be greatly appreciated :)


--
cyberbob20k
------------------------------------------------------------------------
cyberbob20k's Profile:
http://www.excelforum.com/member.php...o&userid=32334
View this thread: http://www.excelforum.com/showthread...hreadid=520901