Quote:
Originally Posted by Div3North
Deadline for entries is, as always, scheduled kick-off time, which is 7.45pm this Tuesday, 18th August. A win would be nice, methinks  ; and there’s some irony in the fact that Someone Who Shall Be Nameless  got a point in the PL for his prediction of a 7-1 Stanley win over Morecambe whereas I got null points for my 2-0 win prediction ………….. perhaps I should suggest to my mate Chimer that we dock points for people who are more than 5 goals off either team’s score!  |
Hum - here's the current formula which decides whether your guess is a spot-on win (5 points), a correct result with the wrong score (draw, 3 or 4 points) or a loss (0 or 1 point):
=IF(H4="","",IF(AND('Pred-1'!$E4=H4,'Pred-1'!$F4=I4),"W",IF('Pred-1'!$G4=J4,"D","L")))
Now, how would I have to change that to add in another condition .......
Suggest away, MATE