help with formula...
 

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

help with formula...
 

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

help with formula...
 

Hi guys
I might be reading it wrong, but wouldn't this give the correct answer.

=IF(B1-((50-A1)*2)=50,"PASS","FAIL")

HTH
Michael

"Peo Sjoblom" wrote:

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

help with formula...
 

Yes it would, however it assumes that the values in A1 and B1 can't switch
places, if you put 55 in A1 and 45 in B1 it will return pass.

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Michael M" wrote in message
...
Hi guys
I might be reading it wrong, but wouldn't this give the correct answer.

=IF(B1-((50-A1)*2)=50,"PASS","FAIL")

HTH
Michael

"Peo Sjoblom" wrote:

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

help with formula...
 

Test results

MCQ TOTAL
Neuroanatomy 47 Fail
Neurophysiology 57.5

Ya that formula works well but still returns an incorrect answer for
the situation shown above where the candidate should have passed with a
score of 50% in neuroanatomy and 51.5% in physiology. thanks again for
all the help, its 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

help with formula...
 

This works no matter which order the two scores are

=IF(MAX(A1:A2)-2*(50-MIN(A1:A2))=50,"pass","fail")


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

help with formula...
 

spot on, thats brilliant, thanks!


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