Football Prediction Game Season 2010-11

[JediMaster]

Hi All

Let me firstly start by adding in advance a big thank you to JBeacucaire and Marcol for whom there contribution has been very invaluable

However I now face a new problem in the calculation of this game so all input would be of great appreciation.

Below is how it works at present

1. the correct score gets 3 points
2. a player who predicts the correct win gets 1 point
3. when no scrores are entered the player gets 0 points

The problem with the formula is that when the outcome of the score is a draw any player whom hasn't entered, scores 3 or 1 point instead of recieving 0 points

Many Thanks In Advance

Jedi

[1.zer0]

=IF($D4="","",IF(AND($D4=H4,$F4=I4),3,IF(SIGN($D4-$F4)=SIGN(H4-I4),1,0)))

extracted from my own prediction game where you can see how it works

[JediMaster]

thanks 1.zer0

however your prediction game does the same if you give the 1st result as 1 1 and no body enters a score then that player is still awarded 1 point and if the score is 0 0 then they score 3 points there must be a formula out there that if the player doesn't enter a score doesn't earn any points!!

Cheers

Lee

[JediMaster]

looking at your game sheet 1.zer0 I do like the way you can scroll in any direction but the names stay locked would love to know how you do that

cheers

lee

[JediMaster]

is there an easy way of getting the particular fixtures rather than entering them all by hand??