19-08-2015, 11:50
|
#38
|
Senior Member+
Join Date: Mar 2006
Location: Pompey
Posts: 3,217
Liked: 1342 times
Rep Power: 107482
|
Re: 2015/16 Prediction League; Game 3 v Mansfield Town (home)
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
__________________
Zero Tolerance of Intolerance
|
|
|