formula help

[n1kk1]

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(C9>F9,'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

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.

"n1kk1" <[email protected]> wrote in
message news:[email protected]...
>
> 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(C9>F9,'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
>