19-08-2015, 16:16
|
#39
|
|
Senior Member+
Join Date: Sep 2008
Location: South(ish) Preston
Posts: 4,177
Liked: 1338 times
Rep Power: 2036281
|
Re: 2015/16 Prediction League; Game 3 v Mansfield Town (home)
Quote:
Originally Posted by Chimer
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  |
A simple "no" would have done ......
 |
|
|