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