Hello, I am trying to work out a point scoring system and have the
following formula

=IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning
Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning
Scores'!F7,"3","0")+IF(OR(AND(C9F9,'Winning Scores'!C7'Winning
Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning
Scores'!F7)),1,0))

Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning
scores spreadsheet, to give 3 points but it is returning 3 points if
C7=F9, and I only want it to relate to C7 - do you know how I would do
this?

I also need to award 1 point if the highest score is chosen but not if
the exact score, hence if the score was '3' '2' and the person chose
these exact numbers 3 points would be awarded but it they chose '3' 1'
only 1 point would be awarded as they chose the winning team

any light you can shed would be greatly appreciated!

thanks
nx


--
n1kk1
------------------------------------------------------------------------
n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173
View this thread: http://www.excelforum.com/showthread...hreadid=551005