help with formula...

[cyberbob20k]

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

 

[Peo Sjoblom]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

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]

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

 

[cyberbob20k]

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

 

[mphell0]

This works no matter which order the two scores are

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

 

[cyberbob20k]

spot on, thats brilliant, thanks!