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

Hi

Similar to an answer I gave earlier to another post:
With your actual score in C2 and D2 and your predicted score in G2 and H2,
try something like this:
=IF(AND(C2=G2,D2=H2),3,IF(OR(AND(C2D2,G2H2),AND( C2<D2,G2<H2)),1,0))
This gives 3 points for an exact score match and 1 point for a result match.
If it doesn't exactly deal with your needs, post back with some examples of
what you'd like!

Andy.

"n1kk1" wrote in
message ...

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