formula help

[n1kk1]

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

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

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

I also need to award 1 point if the highest score is chosen but not i
the exact score, hence if the score was '3' '2' and the person chos
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
n

 

[Guest]

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(C2>D2,G2>H2),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.